Poker Tracker 4 - macOS installation

[Flag_Hippo]

After I clicked the server in pgAdmin4 and I tried to type the password (dbpass), it showes the following message:
connection failed: connection to server at "127.0.0.1", port 5432 failed: FATAL: password authentication failed for user "postgres"
Multiple connection attempts failed. All failures were:
- host: 'localhost', port: '5432', hostaddr: '::1': connection failed: connection to server at "::1", port 5432 failed: FATAL: password authentication failed for user "postgres"
- host: 'localhost', port: '5432', hostaddr: '127.0.0.1': connection failed: connection to server at "127.0.0.1", port 5432 failed: FATAL: password authentication failed for user "postgres"

This means that the wrong password is being used to connect to PostgreSQL. If 'dbpass' (no quotes) is not the correct password and you don't recall the correct password you can override the password requirement - see this guide.

[AndyJ]

After I clicked the server in pgAdmin4 and I tried to type the password (dbpass), it showes the following message:
connection failed: connection to server at "127.0.0.1", port 5432 failed: FATAL: password authentication failed for user "postgres"
Multiple connection attempts failed. All failures were:
- host: 'localhost', port: '5432', hostaddr: '::1': connection failed: connection to server at "::1", port 5432 failed: FATAL: password authentication failed for user "postgres"
- host: 'localhost', port: '5432', hostaddr: '127.0.0.1': connection failed: connection to server at "127.0.0.1", port 5432 failed: FATAL: password authentication failed for user "postgres"

This means that the wrong password is being used to connect to PostgreSQL. If 'dbpass' (no quotes) is not the correct password and you don't recall the correct password you can override the password requirement - see [urlhttps://www.pokertracker.com/guides/PT4/troubleshooting/postgresql-troubleshooting#will-not-connect-wrong-user-or-password]this guide[/url].

I have tried dbpass or postgrespass but still not working. Actually I am pretty sure the password that I typed is dbpass. About overriding the password system, I put those code into terminal but didnot see any response like my attachment. Seems tough to settle the problem.

[Flag_Hippo]

That looks like you didn't use the correct command. You should be using this:

Code: Select all

sudo nano /Library/PostgreSQL/16/data/pg_hba.conf

If you used this:

Code: Select all

sudo nano /Library/PostgreSQL/16/data/pg_hba.conf.

with an additional period at the end that will not work.

[AndyJ]

That looks like you didn't use the correct command. You should be using this:

Code: Select all

sudo nano /Library/PostgreSQL/16/data/pg_hba.conf

If you used this:

Code: Select all

sudo nano /Library/PostgreSQL/16/data/pg_hba.conf.

with an additional period at the end that will not work.

Huge thanks!! It works finally!!

[Flag_Hippo]

Pleased to hear it.