Re: sudo -u postgres psql

2019-09-18 Thread Yves de Champlain
> Le 18 sept. 2019 à 16:06, Bill Cole > a écrit : > > 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 b

Re: sudo -u postgres psql

2019-09-18 Thread Bill Cole
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

Re: sudo -u postgres psql

2019-09-18 Thread Wahlstedt Jyrki
> Yves de Champlain kirjoitti 18.9.2019 kello 19.27: > > Thanks for any hint. Hi, you might need to create a user using ”createuser” command, maybe also create a database. E.g. $ sudo su postgres ’/opt/local/bin/createuser ”options from help” yves” #you have to specify e.g. if you want to be

sudo -u postgres psql

2019-09-18 Thread Yves de Champlain
Hi I can’t find a way to use psql 11 through command line : 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 yves$ sudo -u postgres /opt/local/bin