I want to be able to connect from any PC anywhere to my Database.
Host
- OS: Windows 10
- PostgreSQL: 12.0
Currently all Tutorials say the same: (Thats what i also did)
- Change listen_addresses to
listen_addresses = '*'
in the postgresql.conf - Add
host all all 0.0.0.0/0 md5
in the pg_hba.conf
But they don't say how to connect from the Client Side and they don't pinpoint how secure it is to do so.
Let's say at the Host I Did the above steps and restarted. I created a Database called TablesTest.
How do I connect to this database at the Client? How secure is it?