Hi Paul,
Of courses, you can access pgsql database via TCP/IP based network. You
just have to run
postmaster with -i options and set your network or used security access.
Just set PGPORT to listen to network SQL queries.
I use Apache and mod_perl to access my database and it works very well.
Have fun with PostgreSQL !
Regards,
Gilles Darold.