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