Postgres Pro
Downloads
Home   >   mailing lists

Re: Question about switchover with PG9 replication - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Question about switchover with PG9 replication
Date
Msg-id 20110207144703.GA3438@shinkuro.com
Whole thread Raw
In response to Question about switchover with PG9 replication  (Jean-Armel Luce <jaluce06@gmail.com>)
List pgsql-general
Tree view 
On Mon, Feb 07, 2011 at 09:20:36AM +0100, Jean-Armel Luce wrote:

> Is it possible to do switchover between sites (between PGMaster1 and
> PGMaster2) whithout copying all the database from the new PG master to the
> new PG slave ?

You can't do database replication without copying the whole database, no.

A


--
Andrew Sullivan
ajs@crankycanuck.ca

pgsql-general by date:

Previous
From: Nicolas Grilly
Date:
Subject: Re: Why "copy ... from stdio" does not return immediately when reading invalid data?
Next
From: Vibhor Kumar
Date:
Subject: Re: How to create index on only some of the rows