Hi,

There could be many reasons , sharing most common ones:


  1.
Typo  errors ie case sensitive
  2.
Password change errors
  3.
Incorrect username ,database name , port number
  4.
Configuration issues in hba file
  5.
Privilege issue
  6.
Server Not Restarted/Reloaded or full restart has not taken place for the server

Sharing the psql command for ready reference

psql -h <your_server_ip_or_hostname> -p <your_port> -U <your_username> -d 
<your_database_name>


On 7/9/25 07:06, Jordan Adams wrote:
> Hi Team,
>
> Hope this email finds you well,
>
> Apologies as I am unaware if this is the correct mailing address.
>
> I would however like to inquire about an issue currently being
> experienced with Postgres with one of our external clients.
>
> When doing the setup and following the steps accordingly with regards to
> adding the details for PostgreSQL Unicode ODBC Driver and testing, I run
> into an error where it states the below.
>
> *note - I was provided with the username and password .
>
> "psql: FATAL: password authentication failed"

Was that the complete message?

Not something like:

psql: error: connection to server at "localhost" (127.0.0.1), port 5482
failed: FATAL:  password authentication failed for user "aklaver"


Also provide:

1) Postgres version.

2) Client version.

>
> Please advise if assistance can be provided?
>
>
> Kind Regards
>
> Jordan Adams
>
> IT Support
>
> iSquared Technologies (Pty) Ltd
>
> 021 671 5778





Thanks

Dinesh Nair


________________________________
From: Jordan Adams <jor...@isquared.co.za>
Sent: Wednesday, July 9, 2025 7:36 PM
To: pgsql-gene...@postgresql.org <pgsql-gene...@postgresql.org>
Subject: PostgresSQL Setup error

You don't often get email from jor...@isquared.co.za. Learn why this is 
important<https://aka.ms/LearnAboutSenderIdentification>
Caution: This email was sent from an external source. Please verify the 
sender’s identity before clicking links or opening attachments.
Hi Team,

Hope this email finds you well,

Apologies as I am unaware if this is the correct mailing address.

I would however like to inquire about an issue currently being experienced with 
Postgres with one of our external clients.

When doing the setup and following the steps accordingly with regards to adding 
the details for PostgreSQL Unicode ODBC Driver and testing, I run into an error 
where it states the below.

*note - I was provided with the username and password .

"psql: FATAL: password authentication failed"

Please advise if assistance can be provided?



Kind Regards

Jordan Adams



IT Support

iSquared Technologies (Pty) Ltd

021 671 5778

http://www.isquared.co.za<http://www.isquared.co.za/>

206 Main Road, Claremont, Cape Town 7708





Please send all support emails to 
supp...@isquared.co.za<mailto:supp...@isquared.co.za> and not to an engineer 
directly as they cannot respond to these emails. Please send all procurement 
requests to procurem...@isquared.co.za<mailto:procurem...@isquared.co.za> 
Thanks.

Reply via email to