Skip to main content
Solved

Create PostgreSQL instance with user-specific socket-file location

  • January 10, 2022
  • 2 replies
  • 302 views

Forum|alt.badge.img+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”?

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

View original
Did this answer your question?

2 replies

Meera
Vaulter
Forum|alt.badge.img+7
  • Vaulter
  • 70 replies
  • 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+5
  • Author
  • Bit
  • 13 replies
  • January 12, 2022

Hi Meera

Thank you for the hint - this works fine.

Regards

Markus


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings