Thread

1. PostgresSQL Setup error

   Jordan Adams <jordan@isquared.co.za> — 2025-07-09T14:06:06Z

   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 SUPPORT@ISQUARED.CO.ZA and not to an engineer directly as they cannot respond to these emails. Please send all procurement requests to procurement@isquared.co.za
   

2. Re: PostgresSQL Setup error

   Laurenz Albe <laurenz.albe@cybertec.at> — 2025-07-09T16:03:21Z

   On Wed, 2025-07-09 at 14:06 +0000, Jordan Adams wrote:
   > "psql: FATAL: password authentication failed"
   > 
   > Please advise if assistance can be provided?
   
   Possibly.  That error will cause an error message in the PostgreSQL
   server log.  Ask your DBA to find that error message and tell you
   what it says.
   
   Usually, the message means that you provided the wrong password.
   
   To figure out what is going on, one would have to know how exactly
   you are trying to connect (the connect string, the data source
   definition) and what is in the database server's "pg_hba.conf".
   
   Yours,
   Laurenz Albe
   
   
   
   

3. Re: PostgresSQL Setup error

   Adrian Klaver <adrian.klaver@aklaver.com> — 2025-07-09T16:12:26Z

   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
   > 
   > http://www.isquared.co.za <http://www.isquared.co.za/>
   > 
   > 206 Main Road, Claremont, Cape Town 7708
   > 
   > 
   > 
   > Please send all support emails to SUPPORT@ISQUARED.CO.ZA 
   > <mailto:SUPPORT@ISQUARED.CO.ZA> and not to an engineer directly as they 
   > cannot respond to these emails. Please send all procurement requests to 
   > procurement@isquared.co.za <mailto:procurement@isquared.co.za> Thanks.
   > 
   
   -- 
   Adrian Klaver
   adrian.klaver@aklaver.com
   
   
   
   
   

4. Re: PostgresSQL Setup error

   DINESH NAIR <dinesh_nair@iitmpravartak.net> — 2025-07-10T14:22:48Z

   
   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 <Jordan@isquared.co.za>
   Sent: Wednesday, July 9, 2025 7:36 PM
   To: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
   Subject: PostgresSQL Setup error
   
   You don't often get email from jordan@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 SUPPORT@ISQUARED.CO.ZA<mailto:SUPPORT@ISQUARED.CO.ZA> and not to an engineer directly as they cannot respond to these emails. Please send all procurement requests to procurement@isquared.co.za<mailto:procurement@isquared.co.za> Thanks.