sudo -u postgres psql

Yves de Champlain yesyves at
Wed Sep 18 23:09:09 UTC 2019

> Le 18 sept. 2019 à 16:06, Bill Cole <macportsusers-20171215 at> 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 !


> -- 
> Bill Cole
> bill at or billcole at
> (AKA @grumpybozo and many * addresses)
> Not Currently Available For Hire

More information about the macports-users mailing list