Skip site navigation (1) Skip section navigation (2)

Re: Multiple logical databases

From: "Mark Woodward" <pgsql(at)mohawksoft(dot)com>
To: "Doug McNaught" <doug(at)mcnaught(dot)org>
Cc: "Tino Wildenhain" <tino(at)wildenhain(dot)de>, "Peter Eisentraut" <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org, "Stephan Szabo" <sszabo(at)megazone(dot)bigpanda(dot)com>
Subject: Re: Multiple logical databases
Date: 2006-02-03 15:23:06
Message-ID: 16817.24.91.171.78.1138980186.squirrel@mail.mohawksoft.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
> "Mark Woodward" <pgsql(at)mohawksoft(dot)com> writes:
>
>> The point is, that I have been working with this sort of "use case" for
>> a
>> number of years, and being able to represent multiple physical databases
>> as one logical db server would make life easier. It was a brainstorm I
>> had
>> while I was setting this sort of system for the [n]th time.
>
> It sounds like all that would be needed is a kind of "smart
> proxy"--has a list of database clusters on the machine and the
> databases they contain, and speaks enough of the protocol to recognize
> the startup packet and reroute it internally to the right cluster.
> I've heard 'pgpool' mentioned here; from a quick look at the docs it
> looks similar but not quite what you want.
>
> So your databases would listen on 5433, 5434, etc and the proxy would
> listen on 5432 and route everything properly.  If a particular cluster
> is not up, the proxy could just error out the connection.
>
> Hmm, that'd be fun to write if I ever find the time...

It is similar to a proxy, yes, but that is just part of it. The setup and
running of these systems should all be managed.

In response to

Responses

pgsql-hackers by date

Next:From: Martijn van OosterhoutDate: 2006-02-03 15:25:34
Subject: Re: Passing arguments to views
Previous:From: Magnus HaganderDate: 2006-02-03 15:16:16
Subject: Re: [PATCHES] Fix for running from admin account on win32

pgsql-patches by date

Next:From: Tom LaneDate: 2006-02-03 15:27:30
Subject: Re: TODO-Item: TRUNCATE ... CASCADE
Previous:From: Magnus HaganderDate: 2006-02-03 15:16:16
Subject: Re: [PATCHES] Fix for running from admin account on win32

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group