| From: | "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Password reset |
| Date: | 2020-05-17 13:20:25 |
| Message-ID: | 20200517132025.GA15036@hjp.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2020-05-17 03:32:59 +0000, Jessie Nava wrote:
> Hello, I have lost my username and password. I’ve tried reinstalling but that
> doesn’t allow me to reset my login info.
You didn't say what OS your database is running on (actually, you didn't
even say you lost the password for your database ...).
On Linux systems PostgreSQL is usually set up so that the user
"postgres" can locally connect without a password. So you would ssh into
the server as postgres and then invoke psql and change any passwords.
hp
--
_ | Peter J. Holzer | Story must make more sense than reality.
|_|_) | |
| | | hjp(at)hjp(dot)at | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrus | 2020-05-17 14:41:00 | Hot and PITR backups in same server |
| Previous Message | Ron | 2020-05-17 04:05:37 | Re: Inherited an 18TB DB & need to backup |