Thread: 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