Postgres says my password is invalid
Das Goravani
goravanis at gmail.com
Sat Jan 29 18:55:16 UTC 2022
_hba was not edited…
I am getting the failed message previously typed out
Now I have tried some things, what I know how to do and from your advice
I made ::1/128 as trust and I also put in under IPv4 0.0.0.0/0 as trust
I rebooted
pgAdmin runs and the first password sign in works
But clicking on "Servers" so that I can get to "Databases" brings up the second password box
Putting my password in that brings up the failed connection refused error previously typed out, still
I tried the command you gave for starting postgres, and it said no such directory
I wonder why this all worked the first time through, I did things exactly the same way as they are now
At one point I was able to log on from my machine remotely using my public IP address.. had it all wired, that was the first install
Things went so smoothly then
I have done things exactly the same way on this second and third installs, and it just refuses to work
Mind you I only reinstalled because installation #1 broke.. stopped working, gave first a wrong password error then this failed connection error
> On Jan 29, 2022, at 1:36 PM, Doug Easterbrook via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:
>
> Something must have changed. things never stop working for no reason - there is always a root cause.
>
> 1) open activity monitor and look for processes called ‘postgres’ in all processes . That will tell you if postgres is up. if not, do one of the following:
> a) use the. /library/postgresql/14/bin/pg_ctl -start
> command to get postgres running.
> b) restart your machine.
>
> 2) if postgres is running, can you connect with your application? if not, and you cannot connect with pgadmin, then I highly suspect that something was edited in the
>
> pg_hba.conf .. you it might help to see the bottom of it. Mine looks something like this.
>
> you can always make the local connection and ::1/128 (which pgadmin uses) as ’trust’. that means don’t bother with passwords on the local machine. For that matter, you can make the 127.0.0.1/32 connection as ’trust’ as well.
>
> it is not wise in a production environment to use ‘trust’ and do away with the requirement for passwords — but in development, it can be nice to get you out of a bind.
>
>
> # TYPE DATABASE USER ADDRESS METHOD
>
> # "local" is for Unix domain socket connections only
> local all all trust
> # IPv4 local connections:
> host all all 127.0.0.1/32 md5
> host all all 192.168.0.0/16 scram-sha-256
> # IPv6 local connections:
> host all all ::1/128 trust
> # Allow replication connections from localhost, by a user with the
> # replication privilege.
> local replication all scram-sha-256
> host replication all 127.0.0.1/32 scram-sha-256
> host replication all ::1/128 scram-sha-256
>
>
> if you change pg_hba.conf — then reload the server parameters
>
> /library/postgresql/14/bin/pg_ctl -reload
>
>
>
>
> 3) postgresql.conf — did you edit that recently and make a mistake in it?
>
>
> 4) did you change the permissions of the data directory ?? if so, postgres won’t start
>
>
>
>
>
>
>
> Doug Easterbrook
> Arts Management Systems Ltd.
> mailto:doug at artsman.com
> http://www.artsman.com
> Phone (403) 650-1978
>
>> On January 29, 2022, at 10:00 AM, Das Goravani <goravanis at gmail.com> wrote:
>>
>>
>> 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
>>
>> _____________________________________________________________
>> 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