Re: Postgres User and Password

Hi,

to me it doesn't like a problem of Postgres.
My first guess is, you typed the password wrong. So try another password for
postgres.

But maybe, it's a misconfiguration of your linux box.
Try logging in as root, then su to postgres (without passwordprompt) an then
su to bob.
You should be askef for bob's password. If su to bob fails with the same
error (invalid password) although you typed the right one, it's a problem of
your linux system.

CU,
Andre

----- Original Message -----
From: R Talbot
To: pgsql-general@postgresql.org
Sent: Saturday, July 14, 2001 3:43 AM
Subject: [GENERAL] Postgres User and Password


I was not able to get an RPM build for Calder Edesktop 2.3 & 2.4..
So, I downloaded source for Postgres v 7.0.3 and rolled my own..
I compiled the source to 3 linux boxes and Installed to 3 OS/2 boxes.

My problem is with my Linux Posgres installations.
I compiled as root and installed as root user. As root I can
root@thinkpad root]#  su postgres
root@thinkpad root]#  pg_ctl  start  ...........  Or use postmaster

and successfully start the server.. As I have set all Path and Data
enviormental variables.
But, if I try this as a user
Bob@thinkpad Bob]# su postgres ............. My results is
 password:                                          ............ Then no
matter whats entered, even NULL

........... I get
su: incorrect password

I had no password for User postgres but I finally gave it one but no
help..
I made root and Bob both members of  Group database..     no help.
Once server is started Bob is a postgres user and can start and use
psql...

Very inconvenient to log in as root then su postgres then back to User
login to
development tools..
How can I fix this problem..

Thank You
Bob T


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster