On Saturday 06 October 2001 01:29, Johann Spies wrote: > On Woody - postgresql_7.1release-4_i386.de > > After upgrading to woody I had the following problem with posgtresql: > > > As user postgres: > ----------------------------------- > [EMAIL PROTECTED]:$ createuser js > Shall the new user be allowed to create databases? (y/n) y > Shall the new user be allowed to create more new users? (y/n) y > CREATE USER > [EMAIL PROTECTED]:$ exit > exit > -------------------------------------- > > Now, as user: > --------------------- > $createdb js > psql: IDENT authentication failed for user 'js' > createdb: database creation failed > js-23:21:12-~$ > --------------------- > > Why does this happen? I never had it before. > > > > Johann
The file /etc/postgresql/pg_hba.conf defines the authentication methods. Change the authentication method from ident to whatever you want (This file contains all the documentation you need). -- Meir Kriheli
