Re: Postgres User and Password

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(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
> >
> >

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