Now I am install PostgreSQL 13 in remote cloud server and expose the 5432 port to public network. I add a whitle list in PostgreSQL config file
pg_hba.conf like this:
host all all 127.113.122.1/24 scram-sha-256
127.113.122.x is my public ip address of my network, but the problem is the ip address always change when I restart the Router or other reason. When the IP changed, I have to login into remote server and change the PostgreSQL config file and remove the old ip and add new ip. It make me crazy, I have to change the IP of PostgreSQL config again and again, is there any way to connect PostgreSQL using a stable way? both secure and easy to connect.