Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D56E39FB1EB for ; Wed, 31 Jan 2007 14:23:09 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 70167-01 for ; Wed, 31 Jan 2007 14:23:08 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.238]) by postgresql.org (Postfix) with ESMTP id 9217D9F9F2A for ; Wed, 31 Jan 2007 14:23:06 -0400 (AST) Received: by wr-out-0506.google.com with SMTP id 68so298952wra for ; Wed, 31 Jan 2007 10:23:06 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=FjXCVy/VSJDh6FGh2l/nSuOCS5ktSxR4nRDn0C0Jm1R9Rhks3ngJMhgQWnJaR+2Gu80TzmTf5hvLN5DUGNBW/rvDmn/h51j4hC/0wJPMHtWdf3g2fJtBAhAc2BaeljWv7zPp6lPWaPbQ2TCCLrZC0GaogHy7bhWoeEXAkkS17oE= Received: by 10.90.25.3 with SMTP id 3mr1609542agy.1170267785653; Wed, 31 Jan 2007 10:23:05 -0800 (PST) Received: by 10.90.67.1 with HTTP; Wed, 31 Jan 2007 10:23:05 -0800 (PST) Message-ID: <4544e0330701311023t155b4168o8579c6d27cdd66df@mail.gmail.com> Date: Wed, 31 Jan 2007 12:23:05 -0600 From: "Peter Koczan" To: "Tom Lane" Subject: Re: pg_dumpall problems Cc: pgsql-admin In-Reply-To: <13724.1170203184@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_6832_120071.1170267785576" References: <4544e0330701291303u2ed1d2bclff520f6ecc99e832@mail.gmail.com> <20835.1170110152@sss.pgh.pa.us> <4544e0330701301534r5cb09722i5665f2f406dd29fc@mail.gmail.com> <13724.1170203184@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/302 X-Sequence-Number: 24458 ------=_Part_6832_120071.1170267785576 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline On 1/30/07, Tom Lane wrote: > > "Peter Koczan" writes: > > So, is there any remedy to my problem (see below) short of granting > > superuser access? Is this a bug (which I would then report on the > > appropriate channels)? > > It's not a bug. > > > As for Tom's suggestion, there's no way to specify the database in > > pg_dumpall, only the server, and the same bug occurs if I run as the > user on > > the same server and cluster with the same major version. > > You still haven't responded to my query: did you try it in the same > database that pg_dumpall is connecting to? My guess is that you have > munged the permissions on pg_shadow or pg_authid without understanding > that that will only take effect in the one database you do it in. > pg_dumpall is connecting to either "postgres" or "template1" depending > on version; what's the permissions situation in that database? > > regards, tom lane > I misunderstood your question. I apologize. Granting access on "postgres" worked like a charm. Thank you. Peter ------=_Part_6832_120071.1170267785576 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline

On 1/30/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Peter Koczan" <pjkoczan@gmail.com> writes:
> So, is there any remedy to my problem (see below) short of granting
> superuser access? Is this a bug (which I would then report on the
> appropriate channels)?

It's not a bug.

> As for Tom's suggestion, there's no way to specify the database in
> pg_dumpall, only the server, and the same bug occurs if I run as the user on
> the same server and cluster with the same major version.

You still haven't responded to my query: did you try it in the same
database that pg_dumpall is connecting to?  My guess is that you have
munged the permissions on pg_shadow or pg_authid without understanding
that that will only take effect in the one database you do it in.
pg_dumpall is connecting to either "postgres" or "template1" depending
on version; what's the permissions situation in that database?

                        regards, tom lane

I misunderstood your question. I apologize. Granting access on "postgres" worked like a charm. Thank you.

Peter
------=_Part_6832_120071.1170267785576--