Cannot connect to port 9700 from SQL client

[Pablo S]

I installed in a Ubuntu VM PostgreSQL 13 and it works fine, I can connect from a client SQL GUI. I also installed in the same machine Citus, and it seems to work fine as I can connect locally with psql -p 9700.

But when I try to connect from the client SQL GUI, I get an error saying that couldn't locate the localhost/port.

Any ideas where to look? Also, I don't see 9700 running the command below, is this OK?

postgres@sofubuntu:~$ pg_lsclusters

Ver Cluster Port Status Owner    Data directory              Log file

13  main    5432 online postgres /var/lib/postgresql/13/main /var/log/postgresql/postgresql-13-main.log

[Murat Tuncer]

you would need to start databases as explained step 3 of the documentation

[Pablo S]

I had started the databases, but still cannot connect from the client. Can only connect locally from the console.

[Murat Tuncer]

please check your pg_hba.conf

it should have something like below to allow connections

host      all        all        0.0.0.0/0               md5

hostssl all        all        0.0.0.0/0               md5

also check postgresql.conf 

it should have the setting

listen_addresses='*'

[Pablo]

I have that configured in /etc/postgresql/13/main/pg_hba.conf and  /etc/postgresql/13/main/postgresql.conf

These are the files used by Posgres 13 port 5432 and everything works fine in that port, but not in 9700.

Are Citus files in a different folder?

--
You received this message because you are subscribed to a topic in the Google Groups "citus-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/citus-users/gSQ8l9CwPfc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to citus-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/citus-users/47d3da73-837b-4af2-9124-2cb6ed9e521dn%40googlegroups.com.