am Fri, dem 27.10.2006, um 15:01:09 +0530 mailte Purusothaman A folgendes: > Thanks for your immediate reply. > > I created new role "db1" and database "db1". > > but I cannot login using > psql -Udb1 -ddb1 -hlocalhost > results > Fatal Error : Ident authentication failed for user "db1".
You arn't the user called 'db1'? Either 'su - db1' and then psql, or change the settings in your pg_hba.conf for this database and localhost to 'trust'. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47215, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
