Context
I have an old laptop I'd like to host a database on to serve a MEVN stack hosted on AWS. That MEVN stack currently does use Mongo, the goal is to transition to a local (my laptop) Postgresql DB. Goal is to learn more about Postgres & SQL.
Problem
I am first trying to learn how I can remote into the laptop through another computer however am ending up with Unable to connect to server: connection timeout expired
on pgAdmin 4. I'd like some help on how I can successfully remote into the laptop postgres server.
I have:
- changed postgresql.conf to
listen_address = '*'
on default port 5432 - added
host all all 0.0.0.0/0 md5
to pg_hba.conf - Added an inbound rule in Windows Firewall to allow any IP on port 5432
- Disabled Windows Firewall entirely.
netstat -a -b
shows
[svchost.exe]
TCP 0.0.0.0:5432 MyComputer:0 LISTENING
- Restarted the postgresql Server through Services
Running psql -U postgres -h 192.168.86.229 -p 5432
does not return any errors. Info for registering the server on my desktop in pgAdmin looks like this: