Backups - Mailing list pgsql-novice

From John J. Urbaniak
Subject Backups
Date
Msg-id 42D680FB.1030807@attglobal.net
Whole thread Raw
Responses Re: Backups  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Backups  (Philip Hallstrom <postgresql@philip.pjkh.com>)
List pgsql-novice
Hello,

I am new to this list and new to PostGreSQL.

My PostGreSQL  applications will typically be small networks - maybe
from 1 to 5 users.

The data will be on a server, at, say

  E:\PGSQLDATA

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

Is there anything I am overlooking in such a backup procedure?  Will
that backup everything I need to restore (via unzip) in case of emergency?

Thanks,

John J. Urbaniak
Aviar, Inc.





pgsql-novice by date:

Previous
From: brew@theMode.com
Date:
Subject: Re: Using Batch Files to Create DB Structure
Next
From: Tom Lane
Date:
Subject: Re: Backups