pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: rudi <rudolone@gmail.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Streaming replication: rsync to switchover
Date: Tue, 19 Apr 2011 11:16:08 +0200
Message-ID: <4DAD52D8.1090006@gmail.com> (raw)
In-Reply-To: <BANLkTikrqROJjNiVpmkZorkPM7nUYHZUAw@mail.gmail.com>
References: <4DAC7205.8080203@kemen.it>
	<BANLkTikrqROJjNiVpmkZorkPM7nUYHZUAw@mail.gmail.com>

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




view thread (8+ messages)  latest in thread

Message-ID: <4DAD52D8.1090006@gmail.com>
Permalink:  ../4DAD52D8.1090006@gmail.com/
Also on:    postgresql.org/message-id/4DAD52D8.1090006@gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: rudolone@gmail.com
  Subject: Re: Streaming replication: rsync to switchover
  In-Reply-To: <4DAD52D8.1090006@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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