From:
Tino Wildenhain <tino(at)wildenhain(dot)de>
To:
Mark Woodward <pgsql(at)mohawksoft(dot)com>
Cc:
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 07:16:46
Message-ID:
43E3035E.20406@wildenhain.de (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
Mark Woodward schrieb:
...
> Unless you can tell me how to insert live data and indexes to a cluster
> without having to reload the data and recreate the indexes, then I hardly
> think I am "misinformed." The ad hominem attack wasn't nessisary.
I see you had a usecase for something like pg_diff and pg_patch ;)
...
> If no one sees a way to manage multiple physical database clusters as one
> logical cluster as something worth doing, then so be it. I have a
> practical example of a valid reason how this would make PostgreSQL easier
> to work with. Yes there are work arounds. Yes it is not currently
> unworkable.
I dont see your problem, really ;)
1) if you have very big and very workloaded databases, you often have
them on different physically boxes anyway
2) you can run any number of postmasters on the same box - just put
them to listen on different ip:port.
Now to the management - you say cddb and geodb are managed off host.
So they are not managed on the life server and so you dont need to
switch your psql console to them.
And yeah, its really not a problem, to quit psql and connect
to a different server anyway :-)
If you dont like to type -p otherport, you can either create
aliases with all the arguments or use something like pgadmin3
which enables you to easy switch from database to database,
from host to host as you like.
Now is there any usecase I have missed which you still would
like to have addressed?
Kind regards
Tino Wildenhain
In response to
Responses
pgsql-hackers by date
Next :From: Richard HuxtonDate: 2006-02-03 08:11:58Subject : Re: Multiple logical databasesPrevious :From : Tino WildenhainDate : 2006-02-03 07:09:10Subject : Re: Passing arguments to views
pgsql-patches by date
Next :From: Richard HuxtonDate: 2006-02-03 08:11:58Subject : Re: Multiple logical databasesPrevious :From : Peter EisentrautDate : 2006-02-03 06:26:24Subject : Re: Where to execute the compiled psql
