| 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: | Whole Thread | Raw Message | 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 |