how to connect to CITUS remotely

Question

I have using single node CITUS, my coordinator node running on 9700 and my PostgreSQL running on 5432 I don't know how I can remote connect my CITUS coordinate node

Answer 1

Hello Naveen Kumar Kakarla (Quadrant Resource),

Welcome to the Microsoft Q&A and thank you for posting your questions here.

I understand that you would like to know how to connect to CITUS remotely

There are limited ways to connect remotely: You will need to configure your node parameters using SQL:

-- Ensure that your Citus workers use SSL. 
SELECT run_command_on_workers('show ssl');
-- if not use SSL, 
 ALTER SYSTEM SET citus.node_conninfo TO 'sslmode=prefer';
 SELECT pg_reload_conf();
--Set Up Connection Information
ALTER SYSTEM SET citus.node_conninfo = 'sslrootcert=/path/to/citus-ca.crt sslcrl=/path/to/citus-ca.crl sslmode=verify-full';

Then, ensure correct path is used for SYSTEM SET and use preferred PostgreSQL client or tool to connect to the Citus coordinator node. But if you are connecting from Azure check out the addional resources available from the right side of this page. Especially, https://learn.microsoft.com/en-us/azure/cosmos-db/postgresql/howto-connect?source=recommendations&tabs=pgadmin

Accept Answer

I hope this is helpful! Do not hesitate to let me know if you have any other questions.

** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful ** so that others in the community facing similar issues can easily find the solution.

Best Regards,

Sina Salam