Re: Postgres User and Password

GH wrote:

> > 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
>
> Did you expect anything different?
> Trying to su from an unprivileged user to any user with no password
> should fail miserably.

But I gave user Postgres a password

>
>
> > ........... I get
> > su: incorrect password
> >
> > I had no password for User postgres but I finally gave it one but no
> > help..
>
> That indicates a greater problem with your system. Try resetting it
> so postgres has no password, and try su'ing as root.
>

But this problem exists on 3 Postgres src installs on 2 different Linux
versions where on each I can su from user Bob to all other user with
their passwords without a hitch.
The only user that stops me is Postgres?????

> > Very inconvenient to log in as root then su postgres then back to User
> > login to
> > development tools..
>
> I have no idea why you would do that.
>

You are indicating I should not do what?
Login as root then su to postgres or
Log back to user to use development tools?
I do not auto start any servers because....
I am doing comparative development and each
development machine all 5 have installed
Sybase...DB2...PostgreSQL..MySQL..
I don't want all 4 RDBMS running only the
current working develpment session.
So, I manually start Database servers.

>
> You can have the server start automatically upon boot.
> Beyond that, you have no need to 'su postgres'. You can use psql as any
> user on the machine (provided the permissions are all set correctly).
> Can you be more specific about what the 'problem' is?
>

GH ...See more above.. : )
Comments :The OS/2 version (compiled by Team Italia) installed
automatically in 5 minutes, with folders on the desktop V.7.0.2

and has run perfectly.. As I run caldera 2.3 and 2.4 edesktops,

the Postgres binary RPM will only work with 2.3 Caldera
eserver.
I even called GreatBridge and offered CASH money for help to
set up for Caldera edesktop. They said, BEYOND our SCOPE.
Did not give me confidence in their abilities.
I finally compiled my own from source 3 times with various
problems. i.e. I use jave so I sought out Apache ant.jar..
Not a straight road for my Linux Experience.
Which is why I am still evaluating 4 RDBMS.
Not to mention ;^)
I have tried setting my subcription in General-Postgres to NOMAIL
for 60 days with no sucess. My mailbox gets up to 500 emails a
day.
Postgres has a lot going for it. I like the way it works ( in OS/2).
but I am first a Linux user.
Unless my tools work right, I can't get this project off the ground.

>

Once again thank you very much for your time.. Any further input
is much appreciated.

Bob T

> > Thank You
> > Bob T
>
>