Re: Fwd: Sharing data directories between machines

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Fwd: Sharing data directories between machines
Date: 2013-08-06 19:52:55
Message-ID: 52015417.8010507@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8/6/2013 12:24 PM, John McKown wrote:
> Too bad the PostgreSQL server cannot be in a "Federated" configuration
> so that it "knows" which databases are controlled by which server and
> automatically passes the requests around. Or does it and I just can't
> find it?
> http://en.wikipedia.org/wiki/Federated_database_system
> IBM's DB2 can do this.

run pgbouncer on each system connected to the real database.

its a lot cheaper than DB2, too!!

--
john r pierce 37N 122W
somewhere on the middle of the left coast

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Derek Poon 2013-08-06 21:36:00 Hierarchical numeric data type
Previous Message Andrew Sullivan 2013-08-06 19:37:19 Re: Sharing data directories between machines