Postgres Pro
Downloads
Home   >   mailing lists

Thread: automatic backup

automatic backup

From
"Jefferson Bonamim - Glan Data Sistemas"
Date:
<img class="shape" height="0" src="cid:image004.gif@01CB87D7.CB926B00" style="display:none;width:0;height:0"
v:shapes="_x0000_Mail"v:src="cid:image004.gif@01CB87D7.CB926B00" width="0" /><div class="Section1"><p
class="MsoNormal"><spanstyle="font-family:"Trebuchet MS","sans-serif"; 
color:windowtext">Hello,</span><p class="MsoNormal"><span lang="EN-US" style="font-family:"Trebuchet MS","sans-serif";
color:windowtext">My name is Jefferson and I am an user of Postgres.</span><p class="MsoNormal"><span lang="EN-US"
style="font-family:"TrebuchetMS","sans-serif"; 
color:windowtext">I use the Postgresql 8.0.15 for Windows in some clients and I have a question.</span><p
class="MsoNormal"><spanlang="EN-US" style="font-family:"Trebuchet MS","sans-serif"; 
color:windowtext">I needed to know how to configurate the automatic backup on PG Admin 1.10.</span><p
class="MsoNormal"><spanlang="EN-US" style="font-family:"Trebuchet MS","sans-serif"; 
color:windowtext"> </span><p class="MsoNormal"><span lang="EN-US" style="font-family:"Trebuchet MS","sans-serif";
color:windowtext">I see the FAQ, but I don’t understood anything.</span><p class="MsoNormal"><span lang="EN-US"
style="font-family:"TrebuchetMS","sans-serif"; 
color:windowtext">How do I configure this? </span><p class="MsoNormal"><span lang="EN-US" style="font-family:"Trebuchet
MS","sans-serif";
color:windowtext">Can you help me please?</span><p class="MsoNormal"><span lang="EN-US" style="font-family:"Trebuchet
MS","sans-serif";
color:windowtext"> </span><p class="MsoNormal"><span lang="EN-US" style="font-family:"Trebuchet MS","sans-serif";
color:windowtext">Thanks, </span><p class="MsoNormal"><span lang="EN-US" style="font-family:"Trebuchet
MS","sans-serif";
color:windowtext">Jefferson.</span><p class="MsoNormal"><span lang="EN-US" style="font-family:"Trebuchet
MS","sans-serif";
color:windowtext"> </span><p class="MsoNormal"><span lang="EN-US"> </span></div>

Re: automatic backup

From
"Massa, Harald Armin"
Date:
Hello Jefferson,

to answer your question:

a) PostgreSQL 8.0 was End-Of-Lived in 2007. You should start your sales-pitch of updating to something more recent, as in PostgreSQL 8.4 or 9.0

b) to setup an automatic backup on Windows at a client side with no local DBA (or similiar qualified personel), your success will be better when using pg_dump and "planned tasks".


In a nutshell:

create .cmd files with 
pg_dump -U <username> --format=C <databasename> > dumpfilename.dmp

schedule those .cmd files to run BEFORE any file based backup of the dumpfilename.dmp files happens

(as an exercise: create a daily different dumpfilename via script, run the same .cmd every day)

best wishes,

Harald

On Fri, Nov 19, 2010 at 14:19, Jefferson Bonamim - Glan Data Sistemas <jefferson@glandata.com.br> wrote:

Hello,

My name is Jefferson and I am an user of Postgres.

I use the Postgresql 8.0.15 for Windows in some clients and I have a question.

I needed to know how to configurate the automatic backup on PG Admin 1.10.

 

I see the FAQ, but I don’t understood anything.

How do I configure this?

Can you help me please?

 

Thanks,

Jefferson.

 

 




--
GHUM GmbH
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607

Amtsgericht Stuttgart, HRB 734971
-
persuadere.
et programmare

Re: automatic backup

From
Jeferson Alberto Rodrigues
Date:
Fala xará! Como vai?<br /><br />Eu já fiz um esquema assim, para fazer backup de um determinado banco de dados, em
Linux,utilizando o CRON, que não passa de um Agendador de Tarefas, assim como também tem no Windows.<br /><br />Pelo
queeu vi, no Painel de Controle deve ter um ícone para o Agendador de Tarefas, e nele você adiciona uma tarefa nova,
colocandoa seguinte linha de comando, por exemplo:<br /><br />C:\PostgreSQL\pg_dump -F p -d nome_bd -f arq_saida.sql<br
/><br/>Como este é só um exemplo, não coloquei muitos parâmetros, mas o pg_dump tem vários. Uma documentação mais
completavc encontra aqui:<br /><br />http://pgdocptbr.sourceforge.net/pg80/app-pgdump.html<br /><br />Uma dica bacana
quevc pode utilizar também é gerar um dump através do PgAdmin3, e na tela de debug do dump, ele mostra a sintaxe que
foiutilizada. Copia ela e cola na tarefa agendada. É bem mais fácil assim.<br /><br />Qualquer coisa estou a
disposição.<br/><br />Att.<br /><br />Jeferson Rodrigues<br /><br />Em 19/11/2010 às 11:34 horas, "Jefferson Bonamim -
GlanData Sistemas" <jefferson@glandata.com.br> escreveu:<blockquote style="border-left: 1px solid rgb(204, 204,
204);margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><span>   <span background="cid:image004.gif@01CB87D7.CB926B00"
bgcolor="white"lang="PT-BR" link="#6666FF" vlink="#339933"> <img class="shape" height="0" src="cid:2118tfih4obh"
style="display:none; width: 0pt; height: 0pt;" v:="" v:shapes="_x0000_Mail" width="0" /><div class="Section1"><p
class="MsoNormal"style="margin: 0px;"><span style="font-family: "Trebuchet MS","sans-serif"; color:
windowtext;">Hello,</span><pclass="MsoNormal" style="margin: 0px;"><span lang="EN-US" style="font-family: "Trebuchet
MS","sans-serif";color: windowtext;">My name is Jefferson and I am an user of Postgres.</span><p class="MsoNormal"
style="margin:0px;"><span lang="EN-US" style="font-family: "Trebuchet MS","sans-serif"; color: windowtext;">I use the
Postgresql8.0.15 for Windows in some clients and I have a question.</span><p class="MsoNormal" style="margin:
0px;"><spanlang="EN-US" style="font-family: "Trebuchet MS","sans-serif"; color: windowtext;">I needed to know how to
configuratethe automatic backup on PG Admin 1.10.</span><p class="MsoNormal" style="margin: 0px;"><span lang="EN-US"
style="font-family:"Trebuchet MS","sans-serif"; color: windowtext;"> </span><p class="MsoNormal" style="margin:
0px;"><spanlang="EN-US" style="font-family: "Trebuchet MS","sans-serif"; color: windowtext;">I see the FAQ, but I don’t
understoodanything.</span><p class="MsoNormal" style="margin: 0px;"><span lang="EN-US" style="font-family: "Trebuchet
MS","sans-serif";color: windowtext;">How do I configure this? </span><p class="MsoNormal" style="margin: 0px;"><span
lang="EN-US"style="font-family: "Trebuchet MS","sans-serif"; color: windowtext;">Can you help me please?</span><p
class="MsoNormal"style="margin: 0px;"><span lang="EN-US" style="font-family: "Trebuchet MS","sans-serif"; color:
windowtext;"> </span><pclass="MsoNormal" style="margin: 0px;"><span lang="EN-US" style="font-family: "Trebuchet
MS","sans-serif";color: windowtext;">Thanks, </span><p class="MsoNormal" style="margin: 0px;"><span lang="EN-US"
style="font-family:"Trebuchet MS","sans-serif"; color: windowtext;">Jefferson.</span><p class="MsoNormal"
style="margin:0px;"><span lang="EN-US" style="font-family: "Trebuchet MS","sans-serif"; color: windowtext;"> </span><p
class="MsoNormal"style="margin: 0px;"><span lang="EN-US"> </span></div></span></span></blockquote>