Re: Cold backup with rsync -- WAL files? - Mailing list pgsql-admin

From Craig James
Subject Re: Cold backup with rsync -- WAL files?
Date
Msg-id CAFwQ8reT_6hEkHaZ36981zA6pS39i+AUePyWsc9aoiX7MH6FeQ@mail.gmail.com
Whole thread Raw
In response to Re: Cold backup with rsync -- WAL files?  (Craig James <cjames@emolecules.com>)
Responses Re: Cold backup with rsync -- WAL files?  (Payal Singh <payal@omniti.com>)
List pgsql-admin
While I appreciate suggestions of other ways to do replication, does anyone have an answer to my original question?
...The procedure I'd like to implement is:

  server B is always "cold" (Postgres not running)
  while A is running, rsync A --> B
  stop Postgres on A
  rsync A --> B
  restart Postgres on A

My question is: what about the WAL files?  Do I need to rsync them from A to B too, or can/should I just clean out B's WAL directory, or something else?

Thanks,
Craig




pgsql-admin by date:

Previous
From: Craig James
Date:
Subject: Re: Cold backup with rsync -- WAL files?
Next
From: Payal Singh
Date:
Subject: Re: Cold backup with rsync -- WAL files?