Re: [GENERAL] Postgres Pain Points #3 postgres role

2016-08-11 Thread David G. Johnston
On Thu, Aug 11, 2016 at 1:22 PM, Adrian Klaver wrote: > > The only other thing I have seen is this: > > https://help.ubuntu.com/community/PostgreSQL > > and it shows: > > sudo -u postgres psql postgres > > ​The second postgres redundant - the default database to connect to is the name of the conn

Re: [GENERAL] Postgres Pain Points #3 postgres role

2016-08-11 Thread Adrian Klaver
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

[GENERAL] Postgres Pain Points #3 postgres role

2016-08-11 Thread support-tiger
Relatively minor. All docs say to use "su - postgres" - it doesn't 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