| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Munyutu Waigi <munyutu(dot)waigi(at)mwaloni(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Cc: | Nduku Kitenge <nduku(dot)kitenge(at)mwaloni(dot)com>, "julius(dot)osanjo" <julius(dot)osanjo(at)mwaloni(dot)com> |
| Subject: | Re: Resetting database password |
| Date: | 2018-03-08 13:15:55 |
| Message-ID: | 1520514955.2564.24.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shreeyansh Dba | 2018-03-08 14:02:11 | Re: Resetting database password |
| Previous Message | Laurenz Albe | 2018-03-08 08:25:05 | Re: Update overwriting |