pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
WAL based backup/recovery clarifications 2+ messages / 2 participants [nested] [flat]
* WAL based backup/recovery clarifications @ 2007-03-19 07:58 Sabin Coanda <sabin.coanda@deuromedia.ro> 2007-03-21 00:01 ` Re: WAL based backup/recovery clarifications Bruce Momjian <bruce@momjian.us> 0 siblings, 1 reply; 2+ messages in thread From: Sabin Coanda @ 2007-03-19 07:58 UTC (permalink / raw) To: pgsql-admin 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 ? 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. TIA, Sabin ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: WAL based backup/recovery clarifications 2007-03-19 07:58 WAL based backup/recovery clarifications Sabin Coanda <sabin.coanda@deuromedia.ro> @ 2007-03-21 00:01 ` Bruce Momjian <bruce@momjian.us> 0 siblings, 0 replies; 2+ messages in thread From: Bruce Momjian @ 2007-03-21 00:01 UTC (permalink / raw) To: Sabin Coanda <sabin.coanda@deuromedia.ro>; +Cc: pgsql-admin 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@momjian.us> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-03-21 00:01 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2007-03-19 07:58 WAL based backup/recovery clarifications Sabin Coanda <sabin.coanda@deuromedia.ro> 2007-03-21 00:01 ` Bruce Momjian <bruce@momjian.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox