How do I configure postgresql to be accessible in a network? [Archive]

View Full Version : How do I configure postgresql to be accessible in a network?

zdeh98

02-08-02, 02:17

Hello again!

How do I make my postgresql accessible to all computers in a network? Show this newbie how.

Thanx for the help.:)

eperich

02-08-02, 05:19

First you mast start the postmaster with the "-i" option this activates the TCPIP connections
more info
pg_ctl --help

usually
pg_ctl -D [datadir] -l [logfile] -o "-i"

and second you must define which computers (IP's) arre allowed to connect to the dbserver.
you must define this in the file pg_hba.conf

dblinux

05-03-02, 08:49

Your can configure the network access from pg_hdb.conf file, inside of this file there are all the instructions.
In the last line of the file you can put all the ip addres that can be access on you machine!

Good luck!