Skip to main content
Answer

Create PostgreSQL instance with user-specific socket-file location

  • January 10, 2022
  • 2 replies
  • 328 views

Forum|alt.badge.img+4

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”?

Best answer by Meera

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

2 replies

Meera
Vaulter
Forum|alt.badge.img+7
  • Vaulter
  • Answer
  • January 10, 2022

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


Forum|alt.badge.img+4
  • Author
  • Novice
  • January 12, 2022

Hi Meera

Thank you for the hint - this works fine.

Regards

Markus