I get the following error when trying to create a table with psql: psql: FATAL: Peer authentication failed for user "sql92" The spawned command 'psql -f ./t/t.sql -U sql92' exited unsuccessfully (exit code: 2)
The sql file has two create table commands. I had already created the user 'sql92' with password = '' and createdb privileges. Is there any way to create a user that can be used outside an open database connection in a script? Thanks. Best regards, -Tom