From: | Olivier Reuland <olivier(dot)reuland(at)adm(dot)unige(dot)ch> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | common_fields: permission denied |
Date: | 2003-07-21 12:55:49 |
Message-ID: | 000301c34f87$6931da80$6310c281@Swip |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Olivier Reuland | 2003-07-21 13:26:28 | common_fields: permission denied (more) |
Previous Message | Nick Fankhauser | 2003-07-21 12:32:53 | Re: PG_dump fatal error (second post) |