Original Message
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andrus Sent:
Wednesday, September 27, 2006 2:17 PM To: pgsql-general@postgresql.org
Subject: [GENERAL] How to create nightly backups in Linux
> I'm using the the following scheduler script to create
Andrus wrote:
> I'm bit new to Linux. I'm using white-box linux and Postgres 8.1.4
> How to create backups of database with unique name in every night ?
> Is there some script sample which can be called from /etc/crontab ?
I use the following Z-shell script. Rewriting to bash should be
trivial (p
I'm using the the following scheduler script to create nightly backups in
Windows:
set pgpassword=mypass
set FILENAME=%DATE:~8,4%%DATE:~5,2%%DATE:~2,2%mybackup.backup
"C:\Program Files\PostgreSQL\8.1\bin\pg_dump.exe" -i -Z9 -b -v -f
"%FILENAME%" -F c -h localhost -U postgres mydb
I'm bit new t
