Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 675DD1337B86 for ; Wed, 27 Oct 2010 16:48:52 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 76094-07 for ; Wed, 27 Oct 2010 19:48:45 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from nrccenhts1.nrc.ca (nrccenhts1.nrc.ca [132.246.15.88]) by mail.postgresql.org (Postfix) with ESMTP id BE3161337B5C for ; Wed, 27 Oct 2010 16:48:43 -0300 (ADT) Received: from NRCWSTHCM1.NRC.CA (132.246.216.66) by nrccenhts1.nrc.ca (132.246.15.88) with Microsoft SMTP Server (TLS) id 8.1.436.0; Wed, 27 Oct 2010 15:48:41 -0400 Received: from [132.246.194.17] (132.246.216.202) by WSTMAIL.NRC.CA (132.246.216.66) with Microsoft SMTP Server (TLS) id 8.1.436.0; Wed, 27 Oct 2010 12:48:40 -0700 Message-ID: <4CC88217.90207@nrc-cnrc.gc.ca> Date: Wed, 27 Oct 2010 12:48:39 -0700 From: Isabella Ghiurea Reply-To: isabella.ghiurea@nrc-cnrc.gc.ca Organization: CADC -NRC User-Agent: Thunderbird 2.0.0.19 (X11/20090105) MIME-Version: 1.0 To: "pgsql-admin@postgresql.org" Subject: PG 9.0 streaming replication cfg question Content-Type: text/plain; charset="ISO-8859-1"; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=4.318 tagged_above=-10 required=5 tests=BAYES_20=-0.001, FS_REPLICA=3.599, SARE_SPEC_REPLICA=0.72 X-Spam-Level: **** X-Archive-Number: 201010/197 X-Sequence-Number: 35938 Hi All, I'm trying to configure PG 9.0.1 with streaming replication and WAL shipping in same time, what will be pros and cons for using dedicated user for replication aka: replication_user than the regular user :postgres. Any issues with WAL files ownership when they must be copied and loaded on standby server ? Thank you Isabella -- ----------------------------------------------------------- Isabella A. Ghiurea Isabella.Ghiurea@nrc-cnrc.gc.ca Canadian Astronomy Data Centre |http://www.nrc-cnrc.gc.ca/eng/services/hia/data-centre.html National Research Council of Canada, Herzberg Institute of Astrophysics 5071 West Saanich Road, Victoria BC V9E 2E7, Canada Phone: 250 363-3446 fax: 250 363-0045