Message-ID: <1520514955.2564.24.camel@cybertec.at>
Subject: Re: Resetting database password
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Munyutu Waigi <munyutu.waigi@mwaloni.com>, pgsql-admin@postgresql.org
Cc: Nduku Kitenge <nduku.kitenge@mwaloni.com>, "julius.osanjo"
	 <julius.osanjo@mwaloni.com>
Date: Thu, 08 Mar 2018 14:15:55 +0100
In-Reply-To: 
 <CAJ7PDpiDNzkiCoZC3pMC4U4_LabUz6KB5upr839YrMq9ECXrzQ@mail.gmail.com>
References: 
	<CAJ7PDpiDNzkiCoZC3pMC4U4_LabUz6KB5upr839YrMq9ECXrzQ@mail.gmail.com>
Organization: Cybertec
Content-Type: text/plain; charset="UTF-8"
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit
Precedence: bulk

Munyutu Waigi wrote:
> We desperately need assistance to regain access to our DB, TSAOMS Droplet.
> Our developer (Fred Omala) has gone AWOL and our clients cannot access our solution.

If local connections are allowed "trust" or "peer" authentication in
pg_hba.conf, log into the database server as user "postgres"
and start "psql".  Then you can use ALTER ROLE to change database
passwords.

If all fails, you'll have to stop the database server and start
it in single user mode (as operating system user "postgres"):

postgres --single -D /your/database/directory postgres

Then you are connected with superuser permissions and can change
passwords.

If all that is too complicated for you, contact a support company.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com