Arch Linux

hierarchicalpolymorphist

Member

Registered: 2007-02-22

Posts: 10

Problem: Setting up a postgresql server

Hi all,

I've set up a Postgresql server on Arch following the wiki entry: http://wiki.archlinux.org/index.php/PostgreSQL

I can psql from localhost to access the server, however, when I psql from another host in the same LAN I got "connection refused".

I've already added the name/ip of the other host to /etc/hosts.allow and /var/lib/postgres/pg_hba.conf.  Also I added

postgresql      5432/tcp

to /etc/services

Besides, my two computers can also "see" each other, which means /etc/hosts is set up correctly.  Am I missing anything here?

TIA

---

alias pacman='yaourt'

peque

Member

From: Denmark - Møn

Registered: 2005-06-26

Posts: 441

Re: Problem: Setting up a postgresql server

Well

You´ll have to edit the file - pg_hba.conf (locate it) for accepting connections from other hosts - and remember to setup the netmask,encryptionmode etc

---

Just getting better .... All the time

luke

Member

From: US

Registered: 2004-06-22

Posts: 54

Re: Problem: Setting up a postgresql server

Postgresql's information on pg_hba.conf is here:
http://www.postgresql.org/docs/current/ … -conf.html