Postresql: need a way to initiate a database with a test user

From	Tom Browder <tom.browder@gmail.com>
Newsgroups	linux.debian.user
Subject	Postresql: need a way to initiate a database with a test user
Date	2017-09-15 15:10 +0200
Message-ID	<upYxA-3ec-9@gated-at.bofh.it> (permalink)
Organization	linux.* mail to news gateway

Show all headers | View raw

[Multipart message — attachments visible in raw view] - view raw

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

Back to linux.debian.user | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

Postresql: need a way to initiate a database with a test user Tom Browder <tom.browder@gmail.com> - 2017-09-15 15:10 +0200
  Re: Postresql: need a way to initiate a database with a test user Tom Browder <tom.browder@gmail.com> - 2017-09-15 16:10 +0200
  Re: Postresql: need a way to initiate a database with a test user Zenaan Harkness <zenaan@freedbms.net> - 2017-09-19 14:50 +0200
  Re: Postresql: need a way to initiate a database with a test user Michael Stone <mstone@debian.org> - 2017-09-19 20:10 +0200

csiph-web