Postresql: need a way to initiate a database with a test user
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?