Postgres User Password?

[TBS]

Das

What is most likely is that no, you did not set a Postgres user password upon installation - but its easy to add one now so all is not lost !!

Here is my own note regarding this for Debian :

set postgres password with:
su - postgres
psql
ALTER USER postgres WITH PASSWORD '<newpassword>';
\q
exit

Then restart postgres

Let me know if that gets you there

Andy Hilton
Totally Brilliant Software Inc
Phone (US) : (863) 409 4870
Phone (UK) : 0207 193 8582
Web : www.totallybrilliant.com
Helpdesk : http://totallybrilliant.kayako.com
Email : andyh at totallybrilliant.com
On Oct 4, 2022, 1:12 PM -0400, Das Goravani <goravanis at gmail.com>, wrote:
>
> Hello
>
> When I set up my Debian Server with Postgres, I don’t remember giving the Postgres user a password.
>
> Now it is asking me for the password and nothing works.
>
> The thing is I only use two passwords on everything, and neither of them is working.
>
> I’ve tried everything I can think of, and nothing is working.
>
> Is there a default password for the Postgres user?
>
> The user I CAN Log in as is NOT a superuser and cannot create roles.
>
> Postgres could create roles if I could log in as Postgres.
>
> Because I cannot log in as Postgres, and my other user cannot do anything, so am I SCREWED with this postgres installation?
>
> That would be a bummer.
>
> Das
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com