Solved

Create PostgreSQL instance with user-specific socket-file location

  • 10 January 2022
  • 2 replies
  • 245 views

Badge +5

We are building up a high-available Postgresql cluster by using HA-Proxy, etcd and Patroni.

In this design the postgres-instances are controlled by the patroni-service and are located in a separate directory on a dedicated lvm each. There is also the socket-file stored.

While trying to connect, Commvault is looking in the default directory ‘/var/run/postgresql/’ for the socket-file and then failes, because it is located in an instance-specific directory instead like ‘/data/patroni/instance1/’

Is there a way to tell Commvault this path? Like in the MySQL iDA where there is a field specific for the “Socket File”?

icon

Best answer by Meera 10 January 2022, 18:47

View original

2 replies

Userlevel 3
Badge +7

Hi,

In the Instance Properties dialog box, enter the port number in <socket_file_path>:<port> format.

For example, if the socket file directory is /pg_socket/dir, and you are using port 5432, then type the port number as /pg_socket/dir:5432

 

Regards,

Meera

Badge +5

Hi Meera

Thank you for the hint - this works fine.

Regards

Markus

Reply