Skip site navigation (1) Skip section navigation (2)

common_fields: permission denied (more)

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 (view raw or flat)
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
> 


pgsql-admin by date

Next:From: Nick FankhauserDate: 2003-07-21 16:22:50
Subject: Re: common_fields: permission denied
Previous:From: Olivier ReulandDate: 2003-07-21 12:55:49
Subject: common_fields: permission denied

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group