Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgre 9.0 replication using streaming. - Mailing list pgsql-general

From Karl Denninger
Subject Re: Postgre 9.0 replication using streaming.
Date
Msg-id 4CAB7879.70801@denninger.net
Whole thread Raw
In response to Postgre 9.0 replication using streaming.  (Chris Barnes <compuguruchrisbarnes@hotmail.com>)
List pgsql-general
Tree view
On 10/5/2010 2:12 PM, Chris Barnes wrote:
I would like to know if there is a way to configure 9 to do this.

I have 4 unique databases running on 4 servers.
I would like to have them replicate to a remote site for disaster recovery.

I would like to consolidate these 4 database into one machine and use streaming replication from the 4 masters at out
local collocation site.

Is there a way configure postgres 9.0 to have 4 unique streaming connections from this one machine with the 4 databases
to the 4 databases on 4 machines.

Thanks for your reply,

Chris Barnes
CBIT Inc.

No, but you could set up four separate instances of Postgres and run all four on one machine.

-- Karl
Attachment

pgsql-general by date:

Previous
From: Chris Barnes
Date:
Subject: Postgre 9.0 replication using streaming.
Next
From: Sandeep Srinivasa
Date:
Subject: Postgres, DB2 and Materialized Query Tables (MQTs - DB2s Materialized Views)