Unable to connect to PostgreSQL Database

[HW1]

I am trying to setup a connection to my database. I have the below screenshots:

Simba Driver success

These are the simba driver credentials which are tested successfully.

However when I replicate the same at Alteryx, I get the below error.

Unable to connect

This is my database screengrab:

I am getting the error:

Internal Error SQLDriverConnect: [Simba][PostgreSQL] (10) Error occurred while trying to connect: [SQLState 08S01] could not translate host name "your_PostgreSQL_server" to address: Unknown host

This is what my saved credentials look like:

Saved Connection

I dont understand how to debug this.

What and where should I input so that Alteryx connects to the database where I can read and write to it?

[apathetichell]

Can you connect via in-db instead? could be unhappy with localhost as the host url...

[HW1 · Accepted solution]

Thank you for the help however the issue was when I set up the pgSQL connection driver, I had setup the User DNS and not system DNS. I stumbled upon it accidentally and updated the system DNS on the OS side after which the connections worked. I would mark it as completed.