On Mon, 2003-06-09 at 20:04, Alex wrote: > I did su - postgres but when I try to insert the file I get the same error. > :( > > -bash-2.05b$ psql -U bbstatus -e bbstatus < bbstatus.sql > psql: FATAL: IDENT authentication failed for user "bbstatus" > > Alex > ----- Original Message ----- > From: "Mufit Eribol" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, June 10, 2003 2:49 AM > Subject: Re: Postgresql > > > > Enter 'su postgres' first. Then issue postgresql commands. > > > > Mufit > >
The IDENT authentication failure could be if you aren't running the identd daemon. /etc/init.d/identd start. Don't forget chkconfig --level 2345 identd on, to be sure that it is restarted after reboot. There is also a file in the data directory called pg_ident.conf. This does the linux -> postgres user matchups that Identd uses. So say I have the lines: MYGROUP postgres postgres MYGROUP postgres dbuser MYGROUP myusername postgres MYGROUP myusername guest THATGROUP hisusername guest And in the pg_hba.conf file: # TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE AUTH_ARGUMENT local all trust host all 127.0.0.1 255.255.255.255 trust host mydb 10.0.0.135 255.255.255.255 ident THATGROUP host all 10.0.0.0 255.0.0.0 ident MYGROUP Note that in the pg_hba.conf file the AUTH_TYPE is set to ident and that corresponds to a group in the pg_ident.conf file. You will find a lot of documentation at www.postgresql.org. Ed. -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
