Re: Backups - Mailing list pgsql-novice

From Tom Lane
Subject Re: Backups
Date
Msg-id 19025.1121354130@sss.pgh.pa.us
Whole thread Raw
In response to Backups  ("John J. Urbaniak" <jjurban@attglobal.net>)
Responses Re: Backups
List pgsql-novice
"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

pgsql-novice by date:

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