Hello,
You need to edit your pg_hba.conf file and make it so local (and
remote) connections use the auth method of MD5.
Then when you create (or alter a user) you want to use the WITH
ENCRYPTED PASSWORD '<password>' option.
That way you will have a MD5 hash as the password, and it will always
ask you for a password (even when using psql).
Sincerely,
Joshua Drake
Bruno Wolff III wrote:
> On Fri, Dec 27, 2002 at 20:39:50 +0100,
> zurron@vesta.tmf.bg.ac.yu wrote:
>
>>ok, I want that my data base be safe.
>>so, why if a put this command in the prompt like a regular user
>>
>>zurron@gpsis:~$ /usr/local/pgsql/bin/psql -d colegio -U postgres
>
>
> Probably you don't want to use 'trust' as the authentication method.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
<COMPANY>CommandPrompt - http://www.commandprompt.com </COMPANY>
<CONTACT> <PHONE>+1.503.222-2783</PHONE> </CONTACT>