pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / 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>
  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-21 00:01  Bruce Momjian <bruce@momjian.us>
  parent: Sabin Coanda <sabin.coanda@deuromedia.ro>
  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