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"
Don't use the -U and -e args. psql tries to connect to a database with the same name as your username unless you specify otherwise. that's why you started out with errors about the database "root" not existing. The 'postgres' user has a database, so you can 'su' to that user, and then use the psql tool without additional args.
If you want to do the work as 'bbstatus', first create a database for that user, then 'su bbstatus -', then feed that file to 'psql'.
-- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
