Re: Postgres Pain Points #3 postgres role

On 08/11/2016 10:15 AM, support-tiger wrote:
>  Relatively minor.  All docs say to use "su - postgres" - it doesn't

You talking about this?:

https://www.postgresql.org/docs/9.5/static/install-short.html

That is building from source and shows creating an OS postgres user.

The only other thing I have seen is this:

https://help.ubuntu.com/community/PostgreSQL

and it shows:

sudo -u postgres psql postgres

> seem to work right with linux.  The difference in using the OS user
> postgres and the postgres user (role) postgres is confusing.  Even if we
> set the postgres password to "postgres", it doesn't accept the
> password.  With linux we have found that "sudo -u postgres psql" works.
> But not sure this is right or the best way.
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com