Re: Postgres User and Password - Mailing list pgsql-general

The hell with all this funk !
you should :
- su root
- cd /home/postgres/data/  (wherever your postgres is)
- configure at least *once* your pg_hba.conf

First time, you could set it up to trust everyone on your
network. Then, su postgres, modify users' passwords
(system table pg_user from database template1 -- or, any
existing database), then possibly choose to set up your
pg_hba.conf back with the secure options it certainly had
before. Anyway, RTFM.

R Talbot wrote:
>
> GH wrote:
>
> > > But, if I try this as a user
> > > Bob@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
> >
> >

--
"Le veritable egoiste  est celui qui ne pense qu'a  lui quand il parle
d'un autre." -- Pierre Dac