Skip site navigation (1) Skip section navigation (2)

Re: Backups

From: "John J(dot) Urbaniak" <jjurban(at)attglobal(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Backups
Date: 2005-07-14 15:51:00
Message-ID: 42D689E4.1060903@attglobal.net (view raw or flat)
Thread:
Lists: pgsql-novice
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.
>
>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
>
>  
>
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

Again, thanks.

John

In response to

Responses

  • Re: Backups at 2005-07-14 16:10:17 from John J. Urbaniak

pgsql-novice by date

Next:From: Philip HallstromDate: 2005-07-14 16:09:06
Subject: Re: Backups
Previous:From: Tom LaneDate: 2005-07-14 15:15:30
Subject: Re: Backups

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group