Postgres User Password?

TBS andyh at
Tue Oct 4 17:33:39 UTC 2022


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
ALTER USER postgres WITH PASSWORD '<newpassword>';

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 :
Helpdesk :
Email : andyh at
On Oct 4, 2022, 1:12 PM -0400, Das Goravani <goravanis at>, 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
> Start a new message -> mailto:omnisdev-en at

More information about the omnisdev-en mailing list