Skip site navigation (1) Skip section navigation (2)

RE: Postgres superuser & password on Red Hat; upgrade

From: "Robert D(dot) Nelson" <RDNELSON(at)co(dot)centre(dot)pa(dot)us>
To: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>, Laurel Williams <tech(at)clearwater-inst(dot)com>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: RE: Postgres superuser & password on Red Hat; upgrade
Date: 2001-01-18 13:12:00
Message-ID: 3A6355A3@rba6.rbapro.com (view raw or flat)
Thread:
Lists: pgsql-novice
>  >user, but how can I make Postgres a DBA login with full privileges who
>  >is NOT root? What is the method to give Postgres a new password and/or
>  >discover the old one?
>
>ALTER USER postgres WITH PASSWORD newpassword;

Since he's talking at the su level, perhaps postgres needs a new linux 
password? That would be done, as root, by typing "passwd postgres", then 
following the directions to change the user's password. I'm sure linuxconf 
and other admin tools have this option, but for simple password changes, 
I've found passwd to be the quickest :)


Rob Nelson
rdnelson(at)co(dot)centre(dot)pa(dot)us


pgsql-novice by date

Next:From: Nabil SayeghDate: 2001-01-18 14:28:02
Subject: FOREIGN KEY ... REFERENCES ...
Previous:From: Tom LaneDate: 2001-01-18 01:26:14
Subject: Re: Yikes! Bitten by line length?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group