RE: Postgres User and Password

From: "charlie derr" <webmindforever(at)organicmeat(dot)net>
To: "Justin Clift" <justin(at)postgresql(dot)org>, "R Talbot" <rjtalbo(at)attglobal(dot)net>, <pgsql-general(at)postgresql(dot)org>
Subject: RE: Postgres User and Password
Date: 2001-07-15 12:44:28
Message-ID: NFBBIFIPMKEPOMKBACKIOEAFDGAA.webmindforever@organicmeat.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-07-15 14:35:18 Re: [PATCH] To remove EXTEND INDEX
Previous Message geniusj 2001-07-15 12:00:43 PASSWORD() function for postgresql?