microsoft / pgtester Goto Github PK

I recommend you change the name of the bin/console executable to bin/pgtester to avoid conflicts with other "console" executables.

Sorry for my ignorance but I am not able to use pg_tester in Linux. It fails when starting the server. I tred to manually run the same command, i.e.:

 /usr/bin/pg_ctl start -o '-p 6433' -D /tmp/pg_tester`

And I obtain the following error message:

could not create lock file "/var/run/postgresql/.s.PGSQL.6433.lock": Permission denied

Intuitively, I would expect something like that; an unprivileged user typically should be able to write there. So the question is - is there any way to run pg_tester without root / postgres account? Or what amendments should I make to my user environment that will not be an open security hole?

Thanks for any hints on this problem.

P.S. My colleagues are happily using pg_tester in macOS.