From: | R Talbot <rjtalbo(at)attglobal(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Postgres User and Password |
Date: | 2001-07-14 01:43:57 |
Message-ID: | 3B4FA3DC.1939BAB2@attglobal.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)thinkpad root]# su postgres
root(at)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(at)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
From | Date | Subject | |
---|---|---|---|
Next Message | Mark kirkwood | 2001-07-14 05:02:37 | Re: How Postgresql Compares For Query And Load Operations |
Previous Message | Bruce Momjian | 2001-07-14 00:57:08 | Re: Re: [PATCH] To remove EXTEND INDEX |