Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 2FF64475CA9 for ; Thu, 10 Oct 2002 18:46:44 -0400 (EDT) Received: from socrates.catalyst.net.nz (socrates.catalyst.net.nz [203.96.153.226]) by postgresql.org (Postfix) with ESMTP id 165AF475C2B for ; Thu, 10 Oct 2002 18:46:43 -0400 (EDT) Received: from kant.catalyst.net.nz (hume.catalyst.net.nz [203.96.153.228]) by socrates.catalyst.net.nz (8.12.3/8.12.3/Debian -4) with ESMTP id g9AMkhVN019939; Fri, 11 Oct 2002 11:46:43 +1300 Received: from 127.0.0.1 (ident=unknown) by kant.catalyst.net.nz with esmtp (masqmail 0.2.11) id 17zm4p-1C0-00; Fri, 11 Oct 2002 11:46:43 +1300 Subject: Minimum permissions required for pg_dump as a backup user From: Andrew McMillan To: pgsql-novice@postgresql.org Cc: team-srs@catalyst.net.nz Content-Type: text/plain Organization: Message-Id: <1034290002.2140.494.camel@kant.mcmillan.net.nz> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.1.1 (Preview Release) Date: 11 Oct 2002 11:46:43 +1300 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/81 X-Sequence-Number: 4920 Hi All, Does anyone know what the minimum permission is required to have database backups run as a less privileged user? We have tried granting 'SELECT' to our backup user, but it appears that this is insufficient as pg_dump wants to lock things while it runs. Is there some privilege less than 'UPDATE' that would allow the backups to operate, but otherwise allow the backup user read-only access to the database? Thanks, Andrew. -- --------------------------------------------------------------------- Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St DDI: +64(4)916-7201 MOB: +64(21)635-694 OFFICE: +64(4)499-2267 Survey for free with http://survey.net.nz/ ---------------------------------------------------------------------