pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedadduser postgres
3+ messages / 3 participants
[nested] [flat]
* adduser postgres
@ 2004-09-14 15:38 Yiqun Lin <Yiqun.Lin@NAU.EDU>
2004-09-21 06:33 ` Re: adduser postgres Robert Treat <xzilla@users.sourceforge.net>
2004-09-21 07:28 ` Re: adduser postgres MPaule Torre <torre@obs-vlfr.fr>
0 siblings, 2 replies; 3+ messages in thread
From: Yiqun Lin @ 2004-09-14 15:38 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: adduser postgres
2004-09-14 15:38 adduser postgres Yiqun Lin <Yiqun.Lin@NAU.EDU>
@ 2004-09-21 06:33 ` Robert Treat <xzilla@users.sourceforge.net>
1 sibling, 0 replies; 3+ messages in thread
From: Robert Treat @ 2004-09-21 06:33 UTC (permalink / raw)
To: Yiqun Lin <Yiqun.Lin@NAU.EDU>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: adduser postgres
2004-09-14 15:38 adduser postgres Yiqun Lin <Yiqun.Lin@NAU.EDU>
@ 2004-09-21 07:28 ` MPaule Torre <torre@obs-vlfr.fr>
1 sibling, 0 replies; 3+ messages in thread
From: MPaule Torre @ 2004-09-21 07:28 UTC (permalink / raw)
To: Robert Treat <xzilla@users.sourceforge.net>; Yiqun Lin <Yiqun.Lin@NAU.EDU>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-09-21 07:28 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-09-14 15:38 adduser postgres Yiqun Lin <Yiqun.Lin@NAU.EDU>
2004-09-21 06:33 ` Robert Treat <xzilla@users.sourceforge.net>
2004-09-21 07:28 ` MPaule Torre <torre@obs-vlfr.fr>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox