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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-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.
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2006-02-02 20:20:20 | Re: Backslashes in string literals |
Previous Message | Mark Woodward | 2006-02-02 19:05:03 | Re: Multiple logical databases |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-02-02 21:41:01 | Re: [BUGS] BUG #2171: Differences compiling plpgsql in |
Previous Message | Mark Woodward | 2006-02-02 19:05:03 | Re: Multiple logical databases |