Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 7B48F2E006A for ; Tue, 29 Apr 2008 12:28:42 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 54414-10 for ; Tue, 29 Apr 2008 12:28:38 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by developer.postgresql.org (Postfix) with ESMTP id 7B9852E002D for ; Tue, 29 Apr 2008 12:28:24 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.1/8.14.1) with ESMTP id m3TFSMKN090134 for ; Tue, 29 Apr 2008 12:28:22 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.1/8.14.1/Submit) id m3TF43ZS080948 for pgsql-performance@postgresql.org; Tue, 29 Apr 2008 12:04:03 -0300 (ADT) (envelope-from news) From: Chris Browne X-Newsgroups: pgsql.performance Subject: Re: Replication Syatem Date: Tue, 29 Apr 2008 10:48:28 -0400 Organization: cbbrowne Computing Inc Lines: 16 Message-ID: <60skx467k3.fsf@dba2.int.libertyrms.com> References: <7e4ba9550804280638ie81dc23w472785c83cd38fcf@mail.gmail.com> <60wsmh64f6.fsf@dba2.int.libertyrms.com> <7e4ba9550804282155u655e3ab5o38d2e659b485530d@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1008 (Gnus v5.10.8) XEmacs/21.4.21 (linux) Cancel-Lock: sha1:viFYYP33rwpPR71lEi2GkvbqGuM= To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.2 tagged_above=0 required=5 tests=AWL=-1.699, FS_REPLICA=1.179, SARE_SPEC_REPLICA=0.72 X-Spam-Level: X-Archive-Number: 200804/446 X-Sequence-Number: 29939 meetgaurikanekar@gmail.com ("Gauri Kanekar") writes: > Basically we have some background process which updates "table1" and > we don't want the application to make any changes to "table1" while > vacuum. Vacuum requires exclusive lock on "table1" and if any of > the background or application is ON vacuum don't kick off. Thats the > reason we need to get the site down. VACUUM has not required an exclusive lock on tables since version 7.1. What version of PostgreSQL are you running? -- output = ("cbbrowne" "@" "acm.org") http://linuxdatabases.info/info/sap.html Rules of the Evil Overlord #192. "If I appoint someone as my consort, I will not subsequently inform her that she is being replaced by a younger, more attractive woman.