Re: question

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(at)vesta(dot)tmf(dot)bg(dot)ac(dot)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(at)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>