Обсуждение: adduser postgres
Hello, I have a Fedora core 2 box and just installed postgresSQL 7.3.7. I added a user postgres using the instruction from an installation menu: adduser postgres. Then I tried to su - postgres, but it prompted me "incorrect password". I did not enter any password while adding the user. Could some body help me with this? Many thanks, Yiqun
On Tuesday 14 September 2004 11:38, Yiqun Lin wrote: > Hello, > > I have a Fedora core 2 box and just installed postgresSQL 7.3.7. I added a > user postgres using the instruction from an installation menu: adduser > postgres. Then I tried to su - postgres, but it prompted me "incorrect > password". I did not enter any password while adding the user. Could some > body help me with this? > You should be able to su to the postgres user from root. Otherwise I'd have to point you to "man adduser" since that's an OS problem you have. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
Hye I had a similar problem and I solved it by : * deleting and re-creating the user with passwd * Verify in pg_hba.conf the access and users (It is at this level I had problem from fields -be carefull with the editor- and the "identuser" / try to put trust in a first time) * giving rights to this user to my db * using psql -U username -d dbname I hope it helps mp torre