Re: 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?  I am sure that the data will not exceed 50
> Megabytes, so it should fit on a CD.

if the data won't exceed 50megs I would add step 1a just so you have the
data in a format other than the native postgresql format (say in case for
some freaky reason your machine crashes and *no one* has a copy of that
version of postgres... crazy, but if you have the space...)

1. Vacuum the database

1a. pg_dump the database

2. Stop the postmaster
3. Zip the directory
4. Write the zip file to CD or DVD
5. Start postmaster again