Thread: Postgres superuser password issue--update

Postgres superuser password issue--update

From
Laurel Williams
Date:
Hello all,

Well, it turns out that there was a dead password process which refused
to be killed. This seems to have been the source of all the problems. A
reboot was required and then passwd postgres worked fine. Probably what
happened was that when I did Linuxconf first thing (because that was
what was recommended by the current text I was using), this dead process
occurred and screwed up all the other techniques I tried to change the
Postgres password. If I was a savvier Linux user, I would have known to
check the processes. Moral of the story: Linuxconf is a pain in the ....

However, now that I discovered that 6.5.3 does not offer referential
integrity, we have uninstalled 6.5.3 and installed 7.0.3 in its place,
via source code this time. So now we're awaiting a whole new set of
problems!

Cheers,