Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 26B20475E8A for ; Fri, 11 Oct 2002 00:17:09 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 77591475E24 for ; Fri, 11 Oct 2002 00:17:08 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id g9B4GxhR002184; Fri, 11 Oct 2002 00:17:00 -0400 (EDT) To: Andrew McMillan Cc: pgsql-novice@postgresql.org, team-srs@catalyst.net.nz Subject: Re: Minimum permissions required for pg_dump as a backup user In-reply-to: <1034290002.2140.494.camel@kant.mcmillan.net.nz> References: <1034290002.2140.494.camel@kant.mcmillan.net.nz> Comments: In-reply-to Andrew McMillan message dated "11 Oct 2002 11:46:43 +1300" Date: Fri, 11 Oct 2002 00:16:59 -0400 Message-ID: <2183.1034309819@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/82 X-Sequence-Number: 4921 Andrew McMillan writes: > Does anyone know what the minimum permission is required to have > database backups run as a less privileged user? Backups should be run as the superuser. Don't waste your time trying to kluge up something else. regards, tom lane