Tom Lane wrote:
"John J. Urbaniak" <jjurban@attglobal.net> writes:
I have a question about backups:
Is it ok simply to zip the contents of E:\PGSQLDATA to a zip file and
store this file on a CD or DVD?
Yes, *if* you shut down the postmaster while making the backup.
See
http://www.postgresql.org/docs/8.0/static/backup.html
for discussion --- what you propose is the "file system backup"
approach.
regards, tom lane
Thank you for the quick reply. I think I am going to like working with PostGreSQL. The documentation refers to "tar" - I just wanted to make sure that zip would work as well. I am using Rexx, so I think I can write a CMD to
1. Stop the postmaster
2. Vacuum the database
3. Zip the directory
4. Write the zip file to CD or DVD
5. Start postmaster again
Again, thanks.
John