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
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".
http://support.microsoft.com/kb/308569 (assuming XP)
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)
On Fri, Nov 19, 2010 at 14:19, Jefferson Bonamim - Glan Data Sistemas <
> 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
> 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?
Harald Armin Massa
Spielberger Straße 49
Amtsgericht Stuttgart, HRB 734971
In response to
- automatic backup at 2010-11-19 13:19:30 from Jefferson Bonamim - Glan Data Sistemas
pgadmin-support by date
|Next:||From: Jeferson Alberto Rodrigues||Date: 2010-11-19 15:51:57|
|Subject: Re: automatic backup|
|Previous:||From: Jefferson Bonamim - Glan Data Sistemas||Date: 2010-11-19 13:19:30|
|Subject: automatic backup|