On 18 Sep 2019, at 12:27, Yves de Champlain wrote:
Hi
I can’t find a way to use psql 11 through command line :
Perhaps run 'man psql' for more complete help?
yves$ sudo -u postgres psql
Password:
could not identify current directory: Permission denied
could not identify current directory: Permission denied
psql: could not find own program executable
Presumably this means that you have a system-level user named 'postgres'
but it doesn't have any rights and sudo has stripped its environment
down to being useless.
This is actually fine, since such an account would normally only be used
for running the daemon.
What you should run (assuming that you have a postgres daemon up and
running) is:
psql -U postgres
This also assumes that you've got a 'postgres' user configured for the
running daemon/
--
Bill Cole
[email protected] or [email protected]
(AKA @grumpybozo and many *@billmail.scconsult.com addresses)
Not Currently Available For Hire
