Re: Backups - Mailing list pgsql-novice

From Philip Hallstrom
Subject Re: Backups
Date
Msg-id 20050714090647.I66949@wolf.pjkh.com
Whole thread Raw
In response to Backups  ("John J. Urbaniak" <jjurban@attglobal.net>)
Responses Re: Backups
List pgsql-novice
> 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


pgsql-novice by date:

Previous
From: "John J. Urbaniak"
Date:
Subject: Re: Backups
Next
From: Joel da Silva
Date:
Subject: ...