PostgreSQL Over TCP/IP

Configuring a PostgreSQL server to listen for remote connection requests over TCP/IP:

(File locations as according to a Debian Etch setup)

In /etc/postgresql/8.1/main/pg_hba.conf, add:

# Allow connections from, say, 10.207.110.x
host all all 10.207.110.0/24 md5


In /etc/postgresql/8.1/main/postgresql.conf:

listen_addresses = "*" # listen to requests from all IPs


Finally, assuming the PostgreSQL server is listing on port 5432, update /etc/init.d/firewall.sh to contain

$IPT_bin -A INPUT -i eth0 -p tcp --dport 5432 -j ACCEPT


大马 2007 年财政预算案

真没想到有一天财政预算案竟会和我的工作有关系：

Meanwhile, government-owned research and development organisation Mimos Bhd has been allocated RM162mil to begin research on mobile broadband engines, e-Learning applications, and language technology, especially in Bahasa Malaysia.

（摘自2006年9月2日《星报》）

^_^