Solved

ERROR CONNECTION PostgreSQL SERVER FAILED.

  • 24 August 2022
  • 2 replies
  • 1146 views

Badge +1

Good afternoon, please help, I am trying to connect the postgreSQL database but I get the following error (see image), my passwords are correct for the user "respaldo" but still the error. I have already added another server and it works perfectly.
Thank you. Blessings.

 

 

 

icon

Best answer by Meera 24 August 2022, 04:25

View original

2 replies

Userlevel 7
Badge +16

Can you validate if one of the causes/solutions mentioned for PSQL0001 in this page is related to your situation?

https://documentation.commvault.com/2022e/expert/21723_backup_troubleshooting.html

 

Userlevel 3
Badge +7

Hi Carlos, 

It says peer authentication failed for user “respaldo”. For this user, please check authentication type in pg_hba.conf file. For peer authentication, a mapping to OS user is needed and should be set in pg_ident.conf file. 

For the working instance, is it the same authentication type? 

If config files are updated already, may be a server restart(reload config files) didnt happen and the changes were not effective.

 

Please see the 4th use case here, we have mentioned an example of how peer authentication misconfiguration can cause issue for “postgres” user. Same is applicable here

https://documentation.commvault.com/2022e/expert/21723_backup_troubleshooting.html#cause-4

 

Regards,

Meera

Reply