| 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: | Whole Thread | Raw Message | 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) |