common_fields: permission denied (more)
common_fields: permission denied (more)
От:
Olivier Reuland <olivier.reuland@adm.unige.ch>
Дата:
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 >