[GENERAL] Postgresql - recovery.conf

2011-02-08 Thread For@ll 

Hi,

In file recovery.conf I can define recovery_target_time or 
recovery_target_xid.

I have question where I cand found this information?

For@ll


--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Backup WAL files and pg_standby

2011-02-25 Thread For@ll 

Hi,

I looking for the best solution to backup files using WAL and warm standby.
I have 2 servers A and B. A is a main server (production) on B is runing 
postgres with warm standby. I must now backup databases and WAL to tape 
using a TSM, but on server standby if I using macro %r I have only few 
WAL file.

How should I run a backup to guard against given events:

1) my two database servers is crashed and I must recovery database and 
WAL from tape?

2) how often I must do online backup and backup WAL files?

Albert


--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general