On Wednesday 17 April 2002 11:46 am, Matthew Stanfield wrote:
> I've just reinstalled linux (RedHat 7.2) and PostgreSQL (latest version).
> When I use pg_ctl in a line such as:
> su -c 'pg_ctl start -l /var/lib/pgsql/logs/serverlog
> -D /var/lib/pgsql/data -o -i' postgres
> I get an 'incorrect password' error. On further examination I've found that
> even if using root privileges I can't successfully change the postgres user
> password. Since this user was created by the RPM installation of postgres I
> have no idea what the password is. How do I change the user postgres
> password?
su
passwd postgres
type in your desired password.
The default RPM installation has an invalid password for postgres -- this is
OK, by the way, as an su from root to postgres still works. It's used in the
RPM's initscripts -- it does indeed work. If for some reason an su to
postgres from a root shell does not work, you have other problems. I've
never run into that before -- su to ANY user from root bypasses password
checking.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11