Re: Password reset - Mailing list pgsql-general

From Peter J. Holzer
Subject Re: Password reset
Date
Msg-id 20200517132025.GA15036@hjp.at
Whole thread Raw
In response to Password reset  (Jessie Nava <jessie.nava@jlnavacorp.com>)
List 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@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

Attachment

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Inherited an 18TB DB & need to backup
Next
From: "Andrus"
Date:
Subject: Hot and PITR backups in same server