I am experiencing an issue connecting to a PostgreSQL database hosted on DigitalOcean from pgAdmin on my local machine. Here’s the situation:

1 Server Connection: I can successfully connect to the PostgreSQL database using PuTTY with the same credentials.
2 created new user.
3 pgAdmin Error: When attempting to connect from pgAdmin on my local machine, I receive the following error:

‘unable to connect to port 5432 with user postgres: fatal password authentication failed.’ for both users

Steps Taken:

1 Verified user credentials are correct.
2 Checked that the IP address of my local machine is allowed in the 'DigitalOcean' firewall     settings.
3 Ensured that port 5432 is open and accessible on the server.
4 Verified that the PostgreSQL server is configured to accept connections from external IP addresses.
5 Checked 'pgAdmin' configuration for accuracy.

Questions:

1 Why might this error occur despite being able to connect via PuTTY?
2 Are there additional configuration steps I might be missing?

Any guidance or troubleshooting tips would be greatly appreciated.