RE: Postgres User and Password

+> Very inconvenient to log in as root then su postgres then back to User
+> login to
+> development tools..
+> How can I fix this problem..
+>
+> Thank You
+> Bob T
+>


As Justin said, this is really a *nix question.  The answer to the specific
problem you're having (i still recommend you follow Justin's advice about
using startup scripts) is:

su
(enter root password)
passwd postgres
(enter pw you wish to use for postgres user)
(enter it again)

voila -- you should now be able to su to the postgres user directly from
your user (without su-ing to root first)

    ~c