Necessidades de um Backup
Hoje em dia é essencial que um administrador possua alguma rotina de backup diário do seu banco de dados. A Locaweb possui uma rotina de backup onde faz uma cópia de segurança diária das suas bases de dados. Veja nossa wiki sobre Backup.
Neste documento, mostraremos como criar sua própria rotina de backup para sua base de dados PostgresSQL e armazená-la em sua área de hospedagem.
Alertamos que o uso deste foi homologado apenas para bases com tamanho igual ou inferior à 20MB e por isso não garantimos que o mesmo seja funcional para bases de dados com grandes quantidades de dados!
Criando sua rotina de backups
Criação do arquivo backup_postgres.sh
#!/usr/bin/bash #Variaveis server="postgres01.dominio.com.br" #Servidor postgres login="login_da_base" #login da base pw="*******" #senha nome_temp="all" #nome do arquivo temporário postgres bk="$HOME/backup_postgres/" #Diretório para salvar arquivos de backup nw=$(date "+%Y%m%d") #Buscar pela data nb=3 #número de cópias do banco de dados function backup() { echo "Realizando backup do servidor postgres" export PGPASSWORD=$pw pg_dump -v -F c -h $server $login -U $login -i > "$HOME/$hs.dmp" echo "Compactando arquivo de backup $fn.dmp.gz ..." gzip -f "$HOME/"$fn.dmp if [ -d $bk ]; then continue else mkdir $bk fi cp -f "$HOME/"$hs.dmp.gz "$bk/$nw.dmp.gz" a=0 b=$(ls -t $bk) c=$nb for arq in $b; do a=$(($a+1)) if [ "$a" -gt $c ]; then rm -f "$bk/$arq" fi done } backup postgres
Pronto! Salve este arquivo em sua área de hospedagem, na raíz, no mesmo nível que a pasta public_html/. Este arquivo backup_postgres.sh será o responsável por criar o diretório backup_postgres/ em sua área de hospedagem, na raíz e irá realizar um backup diário da sua base de dados, armazenando sempre os últimos 03 dias. Os arquivos de backups serão compactados e ficarão salvos em:
/home/login-de-FTP/backup_postgres/
Lembre-se apenas de dar permissão 755 no arquivo a ser executado.
Atenção: O código mencionado acima é somente um exemplo. Caso haja dúvidas quanto sua utilização, sugerimos que verifique juntamente a um desenvolvedor de sua confiança.
Uczyniłeś złożoną problem dostępną Pojemną pracę|To wyślij to klejnot Więc zadowolony zacząłem to|Ty musisz niesamowite zdolność wydziału do pisania atrakcyjna treść|To pismo na najwyższym poziomie zdobyłeś modern obserwującego|Twój post był zarówno wnikliwy, jak i uroczo napisany|Jestem zdumiony podczas jak wiele nauczyłem się z tego posta|wykonujesz adept pracę To rekord jest dowodem o tym} {https://kredytero.pl|kredytero.pl|kredyt|kredyty|kredyt online|kredyty online|kredyt przez internet|kredyty przez internet}!
Your post is both educational and entertaining A rare find.
Your wit to captivate readers is remarkable Enormous post.
Your register is both instructive and entertaining A rare find.
Your postal service was both insightful and delightfully written poker for real money.
Every paragraph was a entrance to read Thanks you
Your insights are invaluable Actually cognizant your work.
Your dispatch was not merely informative but also really inspiring love cannabis oil benefits.
You’re doing adept work This post is testimony of that
Thank you for this You’ve helped me accept this text better.
Every paragraph was a gratify to read Thank you
Outstanding post I’m obviously sharing this with my friends
What an enjoyable read You possess a natural talent
Loved every phrase of this You’re a right expert
I really got here throughout your mail and turned into immediately captivated with the aid your insights. Your perspective fish for is both neat and concept-provoking. it is noticeable that you’ve achieved brobdingnagian delve into, and your province to nearest the facts in an appealing manner is wonderful. this is a rationale i’ve been interested in after a while, and your mail has provided me with a mark new outlook. thanks for sharing your cialis otc.
I’m thoroughly impressed by your latest blog post. The way you’ve articulated your points is nothing short of brilliant. Your balanced approach, blending in-depth research with personal anecdotes, makes your writing not only informative but also highly relatable where to get viagra.
I’ve just finished reading your latest blog post, and I must say, it’s outstanding! The depth of your analysis coupled with your engaging writing style made for an exceptional read. What struck me most was your ability to break down complex ideas into digestible, relatable content. Your examples and real-life applications brought the topic to life. I’ve gained a lot from your insights and am grateful for the learning. Keep up the fantastic work – your blog is a treasure trove of knowledge!
Your latest blog post truly resonated with me! The depth of insight and the clarity of your thoughts are commendable. It’s evident that you’ve put a lot of thought and research into this topic, and it shows. Your ability to present complex ideas in such an accessible and engaging manner is a rare skill. Thank you for sharing your knowledge and perspective – it’s been a thought-provoking read and I’m already looking forward to your next piece!
I am constantly browsing online for posts that can aid me. Thanks!
I am constantly looking online for ideas that can assist me. Thank you!
You really make it seem so easy with your presentation but I find this topic to be really something which I think I would never understand. It seems too complex and extremely broad for me. I am looking forward for your next post, I will try to get the hang of it!
Wow! This could be one particular of the most helpful blogs We have ever arrive across on this subject. Basically Excellent. I am also a specialist in this topic therefore I can understand your effort.
Oh my goodness! an incredible article dude. Thank you Nonetheless I am experiencing difficulty with ur rss . Don’t know why Unable to subscribe to it. Is there anybody getting equivalent rss problem? Anyone who knows kindly respond. Thnkx
Definitely, what a magnificent blog and educative posts, I definitely will bookmark your website.Have an awsome day!
Hi, Neat post. There is a problem with your web site in internet explorer, would test this… IE still is the market chief and a large portion of other folks will omit your fantastic writing because of this problem.
whoah this blog is magnificent i love reading your articles. Keep up the great work! You know, a lot of people are searching around for this info, you could help them greatly.
I used to be suggested this web site through my cousin. I’m now not certain whether or not this post is written by way of him as nobody else realize such distinctive approximately my trouble. You’re amazing! Thanks!
You completed a number of nice points there. I did a search on the issue and found nearly all people will have the same opinion with your blog.betflik
Hi there! Someone in my Myspace group shared this website with us so I came to give it a look. I’m definitely loving the information. I’m book-marking and will be tweeting this to my followers! Wonderful blog and amazing design.
You completed a number of nice points there. I did a search on the issue and found nearly all people will have the same opinion with your blog.betflik
I do agree with all the ideas you have presented in your post. They are really convincing and will definitely work. Still, the posts are too short for novices. Could you please extend them a bit from next time? Thanks for the post.