Postgres says my password is invalid

Das Goravani goravanis at gmail.com
Sat Jan 29 18:00:30 UTC 2022


The second part of the failed message says 127.0.0.1 is failing too. So I don’t think changing to that will work. Plus I don’t know WHERE to change to 127.0.0.1 as the IP it try’s on. :-(

Why did it all work the first time, and now after 2 reinstalls it’s not working. I don’t change anything. 



> On Jan 29, 2022, at 12:41 PM, Doug Easterbrook via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:
> 
> try 127.s 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 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 



More information about the omnisdev-en mailing list