NOOB Question: How To Connect to Cluster (Hetzner)?

[nelsonic]

Hi @vitabaks, 👋
We've deployed a Postgres cluster to Hetzner using autobase. 🚀
Following your docs: https://autobase.tech/docs/deployment/hetzner 📖 👌
(good work on the re-brand BTW 😉)

But it's unclear how to connect to the cluster ... 🤷‍♂️
It doesn't appear as though there is a single entry point (load balancer). 🤔

These are the servers:

And load balancers:

But they say "Public network is disabled" when we hover over the IP:

So it's unclear how to connect ...

Reading the docs: https://autobase.tech/docs/management/basic-commands#postgresql

We can connect to Postgres by ssh-ing into the VM e.g:

ssh [email protected]

And run the command (from your docs):

psql -h 127.0.0.1 -p 5432 -U postgres -d postgres -c "select version()"

We get the following output:

But obvs we don't want to have to ssh into a VM to connect to the Postgres DB on it ...

If we ssh into the VM that has the autobase console running on it:

ssh [email protected]

and then attempt to connect to one of the VM/nodes that was deployed/configured by autobase:

export PGPASSWORD='thepasswordinconfig';
psql -h 10.0.1.1 -p 5432 -U postgres -d postgres

Same for attempting to connect via the loadbalancer internal IP:

export PGPASSWORD='thepasswordinconfig';
psql -h 10.0.1.4 -p 6432 -U postgres -d postgres

Both just hang and time-out:

Have tried all combinations of IP address (public/internal) & Port Number and no result.

What am I doing wrong? 🤷‍♂️
Any help much appreciated. Thanks! 🙏

[vitabaks]

Hi @nelsonic

good work on the re-brand BTW

Thanks!

But it's unclear how to connect to the cluster

Our solution is configured by default for production environment, which is why public access is disabled by default. To connect to the database, your application must be on the same network as the database cluster.

If you require access to the database from the internet, enable public access in the load balancer settings. And configure the Firewall rules accordingly.

[vitabaks]

In a future version, the ability to configure public access will be added in the UI - #756

[nelsonic]

Yeah, wasn't expecting the cluster to be publicly accessible ...
Just trying to access from within the same private network.

But looking at the hetzner Networks page it appears there are two Networks:

One which I had created when deploying the initial VM to run the autobase console:

And the other that was created by autobase for the cluster:

I detached the original server from the private-network:

And then deleted the no longer needed network:

Now there is only one network:

Detail:

Attached the VM to the postgres-cluster-network-eu-central Network:

Now there are 6 resources in the net:

And now we can connect!!

psql -h 10.0.1.4 -p 6432 -U postgres -d postgres -c "select version()"

[vitabaks]

Great! I’m glad to hear that you can now connect to the database. Next, just make sure to place the application servers on the same network.

We also plan to add the ability to specify the name of an existing network directly in the UI.