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.
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.
- changed postgresql.conf to
listen_address = '*'on default port 5432
host all all 0.0.0.0/0 md5to pg_hba.conf
- Added an inbound rule in Windows Firewall to allow any IP on port 5432
- Disabled Windows Firewall entirely.
netstat -a -bshows
[svchost.exe] TCP 0.0.0.0:5432 MyComputer:0 LISTENING
- Restarted the postgresql Server through Services
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: