Postgres User Password?
goravanis at gmail.com
Tue Oct 4 17:51:00 UTC 2022
> On Oct 4, 2022, at 1:33 PM, TBS <andyh at totallybrilliant.com> wrote:
> 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>';
Trying the above is giving me a hard time.
When I issue the first line, it asks for the postgres user password
That’s the problem, my passwords don’t work, neither does using the word postgres admin nothing etc
It says authentication failure and quits
So no, this approach is NOT getting me there. Unfortunately.
> 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:
>> 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
> 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