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