Postgres User Password?
andyh at totallybrilliant.com
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
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:
> 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.
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
More information about the omnisdev-en