X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CC79C52A66 for ; Thu, 3 Mar 2005 19:57:08 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 79083-09 for ; Thu, 3 Mar 2005 19:56:59 +0000 (GMT) Received: from mail.libertyrms.com (unknown [207.219.45.62]) by svr1.postgresql.org (Postfix) with ESMTP id 17DF252A5A for ; Thu, 3 Mar 2005 19:56:57 +0000 (GMT) Received: from dba4.int.libertyrms.com ([10.1.3.13] ident=ahammond) by mail.libertyrms.com with esmtp (Exim 4.22) id 1D6wRO-0005qq-P8; Thu, 03 Mar 2005 14:56:58 -0500 Message-ID: <42276C0A.6090401@ca.afilias.info> Date: Thu, 03 Mar 2005 14:56:58 -0500 From: Andrew Hammond Organization: Afilias Canada Corp. User-Agent: Mozilla Thunderbird 0.9 (X11/20041124) X-Accept-Language: en-us, en MIME-Version: 1.0 To: =?ISO-8859-15?Q?K=D6PFERL_Robert?= Cc: pgsql-admin@postgresql.org Subject: Re: How about putting distinct DB-schemas in extra DMBS instances References: In-Reply-To: X-Enigmail-Version: 0.89.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 8bit X-SA-Exim-Mail-From: ahammond@ca.afilias.info X-SA-Exim-Scanned: No; SAEximRunCond expanded to false X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.465 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, INFO_TLD X-Spam-Level: X-Archive-Number: 200503/41 X-Sequence-Number: 16539 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 We do this extensively at Afilias. It is an effective approach has the associated cost of increasing the level of complexity of your systems. I'll speak to the higher ups about posting the script we use to manage multiple postgres instances in production. - -- Andrew Hammond 416-673-4138 ahammond@ca.afilias.info Database Administrator, Afilias Canada Corp. CB83 2838 4B67 D40F D086 3568 81FC E7E5 27AF 4A9A KÖPFERL Robert wrote: | Hi, | | we are fascinated about the point in time recovery feature. In order to have | that feature for each database(schema) extra and to make them disturb each | other even less, we would like to run several postmasters. So for each | DB-schema (3) there should be an extra DBMS running (in an own PGDATA dir). | | Is that possible (of course, I think)? | But is that really what we want or will that make just more problems than | use? | Where's special care needed, Questions all over? | Answer anything. | | | | Thanks. | | ---------------------------(end of broadcast)--------------------------- | TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) iD8DBQFCJ2wIgfzn5SevSpoRAppNAKCNJZl9hIYR2Emaxozu4cxNeWtNzQCdEb2I XwK5c8PeHYDxPibcCPWsJdQ= =s51R -----END PGP SIGNATURE-----