Postgresql 7.3 on FreeBSD

To enable remote access of Postgresql server, edit the file

~pgsql/data/postgresql.conf e.g. /usr/local/pgsql/data/postgresql.conf

and update TCPIP_SOCKET = true.

# /usr/local/etc/rc.d/010.pgsql.sh stop
# /usr/local/etc/rc.d/010.pgsql.sh start

OK. Postgresql is listening at port 5432 now.