Обсуждение: adduser postgres

Поиск
Список
Период
Сортировка

adduser postgres

От
Yiqun Lin
Дата:
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


Re: adduser postgres

От
Robert Treat
Дата:
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

Re: adduser postgres

От
MPaule Torre
Дата:
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