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:
2006-02-02 15:23:44 from "Mark Woodward" <pgsql(at)mohawksoft(dot)com>
2006-02-02 15:13:30 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-02-02 15:19:04 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-02-02 15:57:09 from "Mark Woodward" <pgsql(at)mohawksoft(dot)com>
2006-02-02 16:12:47 from Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
2006-02-02 16:21:21 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2006-02-02 17:40:29 from Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
2006-02-02 19:05:03 from "Mark Woodward" <pgsql(at)mohawksoft(dot)com>
2006-02-02 19:16:30 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-02-02 22:13:24 from Josh Berkus <josh(at)agliodbs(dot)com>
2006-02-03 08:11:58 from Richard Huxton <dev(at)archonet(dot)com>
2006-02-02 23:12:25 from Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
2006-02-02 23:41:16 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2006-02-03 03:14:11 from "Mark Woodward" <pgsql(at)mohawksoft(dot)com>
2006-02-03 07:16:46 from Tino Wildenhain <tino(at)wildenhain(dot)de>
2006-02-03 13:05:48 from "Mark Woodward" <pgsql(at)mohawksoft(dot)com>
2006-02-03 13:24:21 from Doug McNaught <doug(at)mcnaught(dot)org>
2006-02-03 15:23:06 from "Mark Woodward" <pgsql(at)mohawksoft(dot)com>
2006-02-03 15:29:27 from Doug McNaught <doug(at)mcnaught(dot)org>
2006-02-03 18:20:30 from Josh Berkus <josh(at)agliodbs(dot)com>
2006-02-03 19:12:31 from Jeremy Drake <pgsql(at)jdrake(dot)com>
2006-02-03 19:17:21 from Josh Berkus <josh(at)agliodbs(dot)com>
2006-02-03 13:34:25 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-02-03 13:47:05 from Chris Campbell <chris(at)bignerdranch(dot)com>
2006-02-03 17:43:38 from Rick Gigger <rick(at)alpinenetworking(dot)com>
2006-02-03 17:44:00 from Chris Campbell <chris(at)bignerdranch(dot)com>
2006-02-03 20:26:29 from "Mark Woodward" <pgsql(at)mohawksoft(dot)com>
2006-02-03 20:28:54 from "Mark Woodward" <pgsql(at)mohawksoft(dot)com>
2006-02-04 00:37:27 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2006-02-03 16:09:39 from Chris Browne <cbbrowne(at)acm(dot)org>
2006-02-18 21:38:11 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-02-19 15:00:01 from "Mark Woodward" <pgsql(at)mohawksoft(dot)com>
2006-02-19 14:47:51 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2006-02-19 14:58:01 from Douglas McNaught <doug(at)mcnaught(dot)org>
2006-02-19 15:10:29 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-02-19 15:52:18 from "Mark Woodward" <pgsql(at)mohawksoft(dot)com>
2006-02-19 15:56:11 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2006-02-19 16:10:45 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-02-19 17:41:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-02-19 18:55:19 from "Mark Woodward" <pgsql(at)mohawksoft(dot)com>
2006-02-19 16:12:15 from Douglas McNaught <doug(at)mcnaught(dot)org>
2006-02-19 18:57:26 from "Mark Woodward" <pgsql(at)mohawksoft(dot)com>
2006-02-19 16:15:46 from Douglas McNaught <doug(at)mcnaught(dot)org>
2006-02-19 18:59:50 from "Mark Woodward" <pgsql(at)mohawksoft(dot)com>
2006-02-19 20:50:58 from Douglas McNaught <doug(at)mcnaught(dot)org>
2006-02-19 22:14:47 from Steve Atkins <steve(at)blighty(dot)com>
2006-02-19 14:53:45 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-02-19 15:41:04 from "Mark Woodward" <pgsql(at)mohawksoft(dot)com>
2006-02-25 02:28:30 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2006-03-01 00:23:03 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2006-02-03 15:06:02 from Peter Eisentraut <peter_e(at)gmx(dot)net>
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.
In response to
pgsql-hackers by date
Next :From: Kevin GrittnerDate: 2006-02-02 20:20:20Subject : Re: Backslashes in string literalsPrevious :From : Mark WoodwardDate : 2006-02-02 19:05:03Subject : Re: Multiple logical databases
pgsql-patches by date
Next :From: Tom LaneDate: 2006-02-02 21:41:01Subject : Re: [BUGS] BUG #2171: Differences compiling plpgsql in Previous :From : Mark WoodwardDate : 2006-02-02 19:05:03Subject : Re: Multiple logical databases
