On 2/22/08, Shilpa Sudhakar <ssudhakar(at)internode(dot)com(dot)au> wrote:
> I am new to postgres and have been slowly learning the concepts.
> Regarding WAL archiving, we first take a base backup and then save all
> the wal logs for PITR.
1. adjust acrhive_command to save wal's to backup dir
2. execute SELECT pg_start_backup('lable')
3. copy database files
4. execute SELECT pg_stop_backup()
Both the base backup and wal logs are stored in another disk.
> Since the wal logs keep increasing, do we take the base backup every now
> and then so that we can delete the old log files?
Yes, but do not delete old files until the new backup was successfully
How often do we take a base filesystem backup keeping in mind that our
> systems are 24 x 7.
It depends on your diskspace & load.
Any suggestions are appreciated.
Read the manual. It's pretty good & explains almost everything.
UNIX Admin @ Murano Software
In response to
pgsql-admin by date
|Next:||From: Milen Evtimov||Date: 2008-02-22 07:56:44|
|Subject: server process (PID ) was terminated by signal 29|
|Previous:||From: Jaime Casanova||Date: 2008-02-22 05:06:35|
|Subject: Re: Clave usuario postgres|