Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 597956323EB for ; Fri, 16 Apr 2010 16:05:48 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 50005-06 for ; Fri, 16 Apr 2010 19:05:33 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from spinlock.commandprompt.com (host-215.commandprompt.net [207.173.203.215]) by mail.postgresql.org (Postfix) with ESMTP id 1AAD8632393 for ; Fri, 16 Apr 2010 16:05:37 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by spinlock.commandprompt.com (Postfix) with ESMTP id 1E3F834803D; Fri, 16 Apr 2010 12:05:36 -0700 (PDT) Received: from spinlock.commandprompt.com ([127.0.0.1]) by localhost (spinlock.commandprompt.com.commandprompt.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id xvCf3f-pOci9; Fri, 16 Apr 2010 12:05:36 -0700 (PDT) Received: from [192.168.1.100] (unknown [75.142.159.62]) by spinlock.commandprompt.com (Postfix) with ESMTPSA id C1085348035; Fri, 16 Apr 2010 12:05:35 -0700 (PDT) Subject: Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel & transaction "liberation" From: "Joshua D. Drake" Reply-To: jd@commandprompt.com To: Alexandre Leclerc Cc: pgsql-admin@postgresql.org In-Reply-To: <4BC8B0CE.2010401@ipso.ca> References: <4BC8639C.4010202@ipso.ca> <9048.1271429162@sss.pgh.pa.us> <4BC8A623.8090201@ipso.ca> <4BC8638E0200002500030A01@gw.wicourts.gov> <4BC8B0CE.2010401@ipso.ca> Content-Type: text/plain; charset="UTF-8" Organization: Command Prompt, Inc. Date: Fri, 16 Apr 2010 12:05:25 -0700 Message-ID: <1271444725.21263.80.camel@jd-desktop.unknown.charter.com> Mime-Version: 1.0 X-Mailer: Evolution 2.28.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.857 tagged_above=-10 required=5 tests=AWL=0.043, BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201004/224 X-Sequence-Number: 34318 On Fri, 2010-04-16 at 14:47 -0400, Alexandre Leclerc wrote: > I did. :( Shame on me. I just realised while reading doc on postgres > that it is not made for that but only for a single instance at the time. > I hope I did not break anything. How in the world did you pull that off? PostgreSQL checks for that. Either way, if you actually managed to start two services against the same data directory, I hope you have a backup, you can restore from. Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering