sudo -u postgres psql

[Yves de Champlain]

> Le 18 sept. 2019 à 16:06, Bill Cole <macportsusers-20171215 at billmail.scconsult.com> 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 be used for running the daemon.

What actually made me wonder about that part is that ’sudo -u postgres env’ showed that the environment was OK.

> 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/

Right !

Thanks !

yves


> -- 
> Bill Cole
> bill at scconsult.com or billcole at apache.org
> (AKA @grumpybozo and many *@billmail.scconsult.com addresses)
> Not Currently Available For Hire