Re: Backups

OOPS! I guess I have to reverse steps 1 and 2 below.

John


John J. Urbaniak wrote:

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