Postgres says my password is invalid

[Doug Easterbrook]

try 127.0.0.1 as the server ip.


localhost ::1  is not an ip address (as far as I know - but I don’t play ipv6 much).

::1 is ipv6           for 127.0.0.1
localhost is ipv4 for 127.0.0.1
combining them likely isn't valid.   see wikipedia https://en.wikipedia.org/wiki/Localhost



if you want to see what the server is rejecting, you can look at the /Library/Postgresql/14/data/log folder and  — look at the latest log file to see what it is saying.    



Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug at artsman.com
http://www.artsman.com
Phone (403) 650-1978

> On January 29, 2022, at 9:27 AM, Das Goravani <goravanis at gmail.com> wrote:
> 
> 
> Doug, 
> 
> I use the same password for both. 
> 
> In the meantime I reinstalled.
> 
> Now on the second password, and I just reinstalled, it is saying 
> 
> Connection to server at localhost ::1 port 5432 failed: Connection refused. Is the server running on that host and accepting TCP/IP connections?
> 
> I just rebooted too. 
> 
> This all was working. On the first install, then it just decided to not recognize my password.
> 
> Now I’ve reinstalled, and it is having the above problem.
> 
> I am clue less about what to do.
> 
> 
> 
>> On Jan 29, 2022, at 12:16 PM, Doug Easterbrook via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:
>> 
>> there are two passwords on pgadmin
>> 
>> first one, to let you access the application.  you can reset that
>> 
>> second one is the password to a particular server cluster.   That is the postgres install password.
>> 
>> 
>> they are not necessarily the same.
>> 
>> 
>> reset the first one, then connect to your database cluster again.
>> 
>> 
>> Doug Easterbrook
>> Arts Management Systems Ltd.
>> mailto:doug at artsman.com
>> http://www.artsman.com
>> Phone (403) 650-1978
>> 
>>> On January 29, 2022, at 8:59 AM, Das Goravani <goravanis at gmail.com> wrote:
>>> 
>>> 
>>> Now I am distressed.
>>> 
>>> Now pgAdmin says Fatal error password authentication failed for postgres user.
>>> 
>>> It asks for your password as soon as you open pgAdmin
>>> 
>>> I have been using the password I input when I set it up and that has been working
>>> 
>>> Now today it says it doesn’t work
>>> 
>>> I didn’t change a thing, I didn’t change anything
>>> 
>>> Why would it do this?
>>> 
>>> What do I do? Do I have to reinstall postgres?
>>> 
>>> This is a drag.
>>> 
>>> Das
>>> _____________________________________________________________
>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 
>> 
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com