Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade - Mailing list pgsql-general

From David G. Johnston
Subject Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade
Date
Msg-id CAKFQuwa0J5KRvGGW5FC-wMv6wk49A_+npoj9yyOA=ayhh+RKnw@mail.gmail.com
Whole thread Raw
In response to Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade  (Ken Beck <nekkceb.durfee@gmail.com>)
List pgsql-general
On Wed, Mar 28, 2018 at 7:29 PM, Ken Beck <nekkceb.durfee@gmail.com> wrote:
Is it possible a big problem is that the password for user postgres not
longer works for some reason, not sure why. It appears the password can
not be rest or changed without knowing the original, and what I thought
was the original no longer works.

​Pretty sure on Ubuntu default the postgres O/S user​ authenticates itself with PostgreSQL via "peer".  The DB postgres user doesn't have a password.

David J.

pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade
Next
From: Thiemo Kellner
Date:
Subject: Re: Autonomous transaction, background worker