pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
adduser 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