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