Re: Streaming replication: rsync to switchover - Mailing list pgsql-admin

From rudi
Subject Re: Streaming replication: rsync to switchover
Date
Msg-id 4DAD52D8.1090006@gmail.com
Whole thread Raw
In response to Re: Streaming replication: rsync to switchover  (Gerhard Hintermayer <gerhard.hintermayer@gmail.com>)
Responses Re: Streaming replication: rsync to switchover
Re: Streaming replication: rsync to switchover
List pgsql-admin
On 04/19/2011 10:09 AM, Gerhard Hintermayer wrote:
> assuming you have configured rsyncd on the server as:
>
> [postgresql-data]
>      uid = postgres
>      path = /var/lib/postgresql/9.0/data
>      comment = PostgreSQL 9.0 data dir
>      exclude = postmaster.log pg_xlog/* postmaster.pid postgresql.conf

So you keep the old pg_xlog ... But, what about wal that the former
master hasn't yet sent to the slave? I wonder if the former-master could
apply them, becoming out-of-sync with the former-slave (that never
recevied those wal).

thanks

--
rudi


pgsql-admin by date:

Previous
From: H S
Date:
Subject: Re: "postgres" is needed by initdb but was not found
Next
From: Gerhard Hintermayer
Date:
Subject: Re: Streaming replication: rsync to switchover