Re: Backups

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