NpgSQL Connect RDS AWS

Question

I am learning RDS via Npgsql. I could not find documentation telling me how to connect to AWS RDS PostgreSQL from C#.NET program running on premises. In other words I have a code running on a PC desktop or on-premises app server which wants to access a PostgreSQL database on RDS. I get error "No Such Host is Known" from connection Open request. I use the Endpoint string which I copied from AWS console. Please point me to appropriate documentation or examples. I found some JDBC samples/documentation but it does not help me with C#.NET. Thank you very much.

Answer 1

Try connecting with PostgreSQL's psql first. You're right about this probably being some sort of network config issue (or just a badly-copied hostname).