Tom Lane wrote:
>"John J. Urbaniak" <jjurban(at)attglobal(dot)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.
>for discussion --- what you propose is the "file system backup"
> 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
In response to
- Re: Backups at 2005-07-14 16:10:17 from John J. Urbaniak
pgsql-novice by date
|Next:||From: Philip Hallstrom||Date: 2005-07-14 16:09:06|
|Subject: Re: Backups|
|Previous:||From: Tom Lane||Date: 2005-07-14 15:15:30|
|Subject: Re: Backups |