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 31BABD1C4EB for ; Fri, 12 Mar 2004 07:48:53 +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 18773-03 for ; Fri, 12 Mar 2004 03:48:52 -0400 (AST) Received: from ucsns.ucs.co.za (ucs.co.za [196.23.43.2]) by svr1.postgresql.org (Postfix) with ESMTP id BFA32D1BB2A for ; Fri, 12 Mar 2004 03:48:48 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by ucsns.ucs.co.za (Postfix) with ESMTP id 0D2DE2BDF7; Fri, 12 Mar 2004 09:47:58 +0200 (SAST) Received: from ucsns.ucs.co.za ([127.0.0.1]) by localhost (ucsns.ucs.co.za [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 28707-08; Fri, 12 Mar 2004 09:47:33 +0200 (SAST) Received: from ucspost.ucs.co.za (mailgw1.ucs.co.za [196.23.43.253]) by ucsns.ucs.co.za (Postfix) with ESMTP id 2169D2BE01; Fri, 12 Mar 2004 09:47:20 +0200 (SAST) Received: from jhb.ucs.co.za (jhb.ucs.co.za [172.31.1.3]) by ucspost.ucs.co.za (Postfix) with ESMTP id 63D98D9F66; Fri, 12 Mar 2004 09:47:21 +0200 (SAST) Received: from svb.ucs.co.za (svb.ucs.co.za [172.31.1.148]) by jhb.ucs.co.za (Postfix) with SMTP id B30D297684; Fri, 12 Mar 2004 09:47:20 +0200 (SAST) Date: Fri, 12 Mar 2004 09:47:14 +0200 From: Stef To: Tom Lane Cc: pgsql-admin@postgresql.org Subject: Re: Multiple postmasters for one data directory... Message-Id: <20040312094714.395db1da.svb@ucs.co.za> In-Reply-To: <20180.1079020481@sss.pgh.pa.us> References: <20040311165256.5a68e02a.svb@ucs.co.za> <20180.1079020481@sss.pgh.pa.us> X-Mailer: Sylpheed version 0.9.6claws (GTK+ 1.2.10; i386-pc-linux-gnu) User-Agent: sillypheed-claws (anti-aliased) X-Face: GFoC95e6r)_TTG>n~=uFLojP=O~4W@Ms]>:.DMm/')(z3\Mwj^XP@? Q:3";lD.OM1"^mDu}2NJ@US:)dO:U*iY5EM50&Tx. X-Operating-System: sid X-X-X: _-^-_ Mime-Version: 1.0 Content-Type: multipart/signed; protocol="application/pgp-signature"; micalg="pgp-sha1"; boundary="Signature=_Fri__12_Mar_2004_09_47_14_+0200_e7wmONhera_/AkLE" X-Virus-Scanned: by amavisd-new at ucs.co.za X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/204 X-Sequence-Number: 12773 --Signature=_Fri__12_Mar_2004_09_47_14_+0200_e7wmONhera_/AkLE Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 7bit Tom Lane mentioned : => Get out your backup tapes, because what you have on disk now is just a => pile of inconsistent bits. I haven't actually done anything but SELECT's from the shared postmaster, and it was a test machine. Phew!! Glad I asked first... I think the way I'll do it, is by using initlocation, as this will solve all my problems, except for having to reload all databases. Thanks for the enlightening answer! Kind Regards Stefan --Signature=_Fri__12_Mar_2004_09_47_14_+0200_e7wmONhera_/AkLE Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iQCVAwUBQFFrCLoLc+HYd7LFAQJwKwP/cgDBIEVv7vP51wsCEwbtI+6ldUxb9Til MuQRcNSbXNBjYFBgMnZB7w1/qsWhMbnqJnbnzAT92Xo/F69ryzJkLKQJcoTKdXhu Or0fN1NJEBbfsBmcCXouAOuNrPmdMobI3x27EsxegCNL4S976mCSLWZafV2VHmOg 0f1vjfB3Mn4= =8fto -----END PGP SIGNATURE----- --Signature=_Fri__12_Mar_2004_09_47_14_+0200_e7wmONhera_/AkLE--