X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 893E89FA5C8 for ; Thu, 8 Jun 2006 12:04:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 60447-08 for ; Thu, 8 Jun 2006 12:04:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 01B649F9EF3 for ; Thu, 8 Jun 2006 12:04:25 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k58F4JB8027637; Thu, 8 Jun 2006 11:04:19 -0400 (EDT) To: "soni de" cc: "Jim C. Nasby" , pgsql-performance@postgresql.org Subject: Re: Regarding ALTER Command In-reply-to: <9f2e40a90606072307s7107630eh60e01c4f792fe3a8@mail.gmail.com> References: <9f2e40a90606070543l1066f162v19fc0887d916e2bb@mail.gmail.com> <20060607145020.GT45331@pervasive.com> <9f2e40a90606072307s7107630eh60e01c4f792fe3a8@mail.gmail.com> Comments: In-reply-to "soni de" message dated "Thu, 08 Jun 2006 11:37:44 +0530" Date: Thu, 08 Jun 2006 11:04:19 -0400 Message-ID: <27636.1149779059@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/86 X-Sequence-Number: 19443 "soni de" writes: > One more thing I have to mention is that we are using 2 postmasters running > on different machines and both are accessing same data directory. (i.e both > the machines uses same tables or the databases) The above is guaranteed NOT to work. I'm surprised you haven't already observed wholesale data corruption. But don't worry, you will soon. regards, tom lane