Re: Cold backup with rsync -- WAL files?

From: Craig James <cjames(at)emolecules(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Cold backup with rsync -- WAL files?
Date: 2013-12-06 18:39:30
Message-ID: CAFwQ8reT_6hEkHaZ36981zA6pS39i+AUePyWsc9aoiX7MH6FeQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Payal Singh 2013-12-06 18:54:10 Re: Cold backup with rsync -- WAL files?
Previous Message Craig James 2013-12-06 15:37:28 Re: Cold backup with rsync -- WAL files?