From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Munyutu Waigi <munyutu.waigi@mwaloni.com>
To: pgsql-admin@postgresql.org
Cc: Nduku Kitenge <nduku.kitenge@mwaloni.com>
Cc: julius.osanjo <julius.osanjo@mwaloni.com>
Subject: Re: Resetting database password
Date: Thu, 08 Mar 2018 14:15:55 +0100
Message-ID: <1520514955.2564.24.camel@cybertec.at> (raw)
In-Reply-To: <CAJ7PDpiDNzkiCoZC3pMC4U4_LabUz6KB5upr839YrMq9ECXrzQ@mail.gmail.com>
References: <CAJ7PDpiDNzkiCoZC3pMC4U4_LabUz6KB5upr839YrMq9ECXrzQ@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, munyutu.waigi@mwaloni.com, nduku.kitenge@mwaloni.com, julius.osanjo@mwaloni.com
Subject: Re: Resetting database password
In-Reply-To: <1520514955.2564.24.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox