common_fields: permission denied - Mailing list pgsql-admin

From Olivier Reuland
Subject common_fields: permission denied
Date
Msg-id 000301c34f87$6931da80$6310c281@Swip
Whole thread Raw
Responses Re: common_fields: permission denied  ("Nick Fankhauser" <nickf@ontko.com>)
List pgsql-admin
Hi there,

I have a problem accessing my postgres database when using a specific
user...

If I run and pg_dumpall using the postgres linux user I have no problem.
Then I tried to add a new user only for one database (let say "user1" and
"db1"). My pg_hba.conf looks like :

local   all         all                                             trust
host    all         all         127.0.0.1         255.255.255.255   trust
host    all         all         0.0.0.0           255.255.255.255   reject

When I try to run "./pg_dump --username=user1 --password db1" I have an
error saying :

pg_dump: Attempt to lock table "common_fields" failed.  ERROR:
common_fields: permission denied


Any idea ?

Thanks

Oliver


pgsql-admin by date:

Previous
From: Dani Oderbolz
Date:
Subject: Re: PG_dump fatal error (second post)
Next
From: "Nick Fankhauser"
Date:
Subject: Re: common_fields: permission denied