I have PostgreSQL version 9.5 installed at my machine (Windows 7 Enterprise x64 bit version). I have several databases in schema 'public'. I would like to use/access one of these databases from another machine (Windows 7) using LAN connectivity (so that this database may act as a shared database between two machines). I was wondering whether is it possible to do through "listen_addresses" option in postgresql.conf dialogue window? If not, is there any alternative way to do this?
Yes, two things that need to happen:
- Your database must be listening on a port and ip to external connections. For this you need to modify
postgresql.conf, you may choose to use the new-ish method of
ALTER SYSTEMto do that.
- Your database must be properly configured to authenticate someone coming in externally. To do this you must add a host or preferably
pg_hba.conffor that ip/port.
Read the article Configuring PostgreSQL to Accept Connections From Computers on Your Network where it is explained with screen shots.