Обсуждение: Problem with postgres

when I am logging on Postgres i haven't to give a password

How can I do in order to have one ?

when I want to pg_dump a database with user postgres, this error appears :
permisson not allowed
whereas with user root it is good

how can i resolve this problem ?

THANKS



__________________________________________________
Voila vous propose une boite aux lettres gratuite sur Voila Mail:
http://mail.voila.fr

On Wed, 25 Apr 2001, benoit.le-dizes@voila.fr wrote:

> when I am logging on Postgres i haven't to give a password
>
> How can I do in order to have one ?

Look at the pg_hba.conf file (normally in $PGDATA directory).

You'll want to change the 'trust' to 'password' for local users.

--
Joel Burton   <jburton@scw.org>
Director of Information Systems, Support Center of Washington