sudo -u postgres psql
Yves de Champlain
yesyves at gmail.com
Wed Sep 18 23:09:09 UTC 2019
> 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/
> Bill Cole
> bill at scconsult.com or billcole at apache.org
> (AKA @grumpybozo and many *@billmail.scconsult.com addresses)
> Not Currently Available For Hire
More information about the macports-users