From: | Olivier Reuland <olivier(dot)reuland(at)adm(dot)unige(dot)ch> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | common_fields: permission denied (more) |
Date: | 2003-07-21 13:26:28 |
Message-ID: | 000001c34f8b$b12a6560$6310c281@Swip |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Just to add more info I made a "pg_dumpall | grep user1" to be sure that the
user was really created, which sounds to be the case :
CREATE USER user1 WITH SYSID 100 NOCREATEDB NOCREATEUSER;
> 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 | Nick Fankhauser | 2003-07-21 16:22:50 | Re: common_fields: permission denied |
Previous Message | Olivier Reuland | 2003-07-21 12:55:49 | common_fields: permission denied |