Kresimir Pendic - Mon, 2009/11/02 - 01:30

Hi, 

I cant connect to postgre server, on the network with pgadminIII ?

Can anyone help with some idea ?

Forum: 
Support
Liraz Siri's picture

Liraz Siri - Mon, 2009/11/02 - 06:26
By default we configure appliances not to allow external connections to the database for security reasons. You'll need to change the PostgreSQL configuration to allow that if you want to connect with an external client.

Kresimir Pendic - Mon, 2009/11/02 - 12:14

Thank you Liraz for info,

i will try to play with postgres config files to allow '*'  connections

not only localhost .. i think that would be enough .. 

 

.kp

 .k.p.

Alon Swartz's picture

Alon Swartz - Mon, 2009/11/02 - 12:43

This might help...

Configure postgres to listen for remote connections

CONF=/etc/postgresql/8.3/main/postgresql.conf
sed -i "s/#listen_addresses = 'localhost'/listen_addresses = '*'/" $CONF

Configure postgres to accept remote connections

# configure postgres to accept remote connections
cat >> /etc/postgresql/8.3/main/pg_hba.conf <<EOF
# Accept all IPv4 connections - CHANGE THIS!!!
host    all         all         0.0.0.0/0             md5
EOF
Alon Swartz's picture

Alon Swartz - Tue, 2009/11/03 - 13:04
For those interested, I just created this doc page: How to configure databases (MySQL, PostgreSQL) to allow remote access

Add new comment