External Connections for a PostgreSQL Server

Picture of Mertech Mertech : Feb 24, 2008 2:08:00 PM

Databases

By default, a PostgreSQL server doesn't allows external connections.
How to Change this Behavior?

Edit pg_hba.conf file

Insert the rules for external connections

Example that allows all clients from your network as 192.168.0.1:

# TYPE  DATABASE    USER        CIDR-ADDRESS              METHOD
# IPv4 local connections:
host    all         all         127.0.0.1/32              md5
host    all         all         192.168.0.0 255.255.255.0 password
# IPv6 local connections:
#host   all         all         ::1/128                   md5

Why Migrate from Btrieve to PostgreSQL and other Relational Databases?

Riaz Merchant: Oct 28, 2024 6:12:41 AM

Introduction Many independent software vendors (ISV) and corporate users still rely on applications that use a category of database collective called...