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(dot)klaver(at)aklaver(dot)com