subject:"\[ADMIN\] WAL based backup\/recovery clarifications"

Re: [ADMIN] WAL based backup/recovery clarifications

2007-03-20 Thread Bruce Momjian

Sabin Coanda wrote: > Hi there, > > I'd like to use WAL, but I need some clarifications about the > backup/recovery procedure. > > In Postgresql v8.2.3 documentation, I found I have to make backup between > pg_start_backup/pg_stop_backup executions, using tar/cpio tools. > > May I use pg_dumpa

[ADMIN] WAL based backup/recovery clarifications

2007-03-19 Thread Sabin Coanda

Hi there, I'd like to use WAL, but I need some clarifications about the backup/recovery procedure. In Postgresql v8.2.3 documentation, I found I have to make backup between pg_start_backup/pg_stop_backup executions, using tar/cpio tools. May I use pg_dumpall instead ? Is it enough to restore t