HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Using postgres database from another computer

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
postgresdatabaseanotherusingcomputerfrom

Problem

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?

Solution

Read the article Configuring PostgreSQL to Accept Connections From Computers on Your Network where it is explained with screen shots.

Context

StackExchange Database Administrators Q#142467, answer score: 4

Revisions (0)

No revisions yet.