[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

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?


Best regards,


Reply to: