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

Re: Multiple logical databases

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Mark Woodward <pgsql(at)mohawksoft(dot)com>
Cc: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>,pgsql-hackers(at)postgresql(dot)org
Subject: Re: Multiple logical databases
Date: 2006-02-02 19:16:30
Message-ID: 20060202191630.GB25752@svana.org (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
On Thu, Feb 02, 2006 at 02:05:03PM -0500, Mark Woodward wrote:
> My issue is this, (and this is NOT a slam on PostgreSQL), I have a number
> of physical databases on one machine on ports 5432, 5433, 5434. All
> running the same version and in fact, installation of PostgreSQL.

One way of acheiving this would be to allow the PGHOST and/or PGPORT
variables to be lists and when you connect it tries each combination
until it finds on that works. Maybe not as clean but a lot easier to
implement.

Unless ofcourse you want "psql -l" to list all databases in all
clusters...

I think it would be better to put the intelligence into libpq rather
than trying to create more servers...

Have a nice day,
-- 
Martijn van Oosterhout   <kleptog(at)svana(dot)org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

In response to

pgsql-hackers by date

Next:From: Kevin GrittnerDate: 2006-02-02 20:20:20
Subject: Re: Backslashes in string literals
Previous:From: Mark WoodwardDate: 2006-02-02 19:05:03
Subject: Re: Multiple logical databases

pgsql-patches by date

Next:From: Tom LaneDate: 2006-02-02 21:41:01
Subject: Re: [BUGS] BUG #2171: Differences compiling plpgsql in
Previous:From: Mark WoodwardDate: 2006-02-02 19:05:03
Subject: Re: Multiple logical databases

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