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_dumpall instead ? Is it enough to restore the database later > with WAL ? No, you need a binary backup, not a logical backup. > If I cannot use pg_dumpall, please tell me exactly what are the directories > that have to be archived. I note that I use a standard configuration on > Windows. All under "data". Isn't the documentation clear? -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
