Postgres Pro
Downloads
Home   >   mailing lists

Re: automatic backup - Mailing list pgadmin-support

From Massa, Harald Armin
Subject Re: automatic backup
Date
Msg-id AANLkTinz2W+DHAmJG+QOcyU+YDD=C9HZwC5Jr8Pk3C-f@mail.gmail.com
Whole thread Raw
In response to automatic backup  ("Jefferson Bonamim - Glan Data Sistemas" <jefferson@glandata.com.br>)
List pgadmin-support
Tree view
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

pgadmin-support by date:

Previous
From: "Jefferson Bonamim - Glan Data Sistemas"
Date:
Subject: automatic backup
Next
From: Jeferson Alberto Rodrigues
Date:
Subject: Re: automatic backup