X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id BBC0ED1D8DA for ; Thu, 11 Mar 2004 15:54:44 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 09679-04 for ; Thu, 11 Mar 2004 11:54:43 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 2C0BBD1B4C5 for ; Thu, 11 Mar 2004 11:54:37 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i2BFsfhc020181; Thu, 11 Mar 2004 10:54:41 -0500 (EST) To: Stef Cc: pgsql-admin@postgresql.org Subject: Re: Multiple postmasters for one data directory... In-reply-to: <20040311165256.5a68e02a.svb@ucs.co.za> References: <20040311165256.5a68e02a.svb@ucs.co.za> Comments: In-reply-to Stef message dated "Thu, 11 Mar 2004 16:52:56 +0200" Date: Thu, 11 Mar 2004 10:54:41 -0500 Message-ID: <20180.1079020481@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/200 X-Sequence-Number: 12769 Stef writes: > I've managed to make such a database cluster on a separate postmaster, > and re-linked all the database directories to point to the data directories > of all the other postmasters. > Although this workaround seems to be working rather well, I know for one > thing that it could be disastrous to have two postmasters running on the > same data directory at the same time, so I'll ensure that that doesn't happen. > Is what I'm doing VERY bad, and are there more things I'm overlooking? > Can this setup possibly break everything? I'm afraid you have already shot yourself in the foot. The above cannot work because there is no way to share pg_xlog or pg_clog across database clusters. You have now got transaction numbers from the "shared" postmaster inserted into the other databases, and when you go back to separate postmasters you will have corruption. I'm surprised you do not already see inconsistencies, because if the "shared" installation was a fresh one then it would probably see most of the committed transaction numbers of the other databases as being "in the future". Get out your backup tapes, because what you have on disk now is just a pile of inconsistent bits. regards, tom lane