Postgres User and Password

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

Responses

Browse pgsql-general by date

  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