Accessing PostgreSQL Over A Network...

Hi all,

I have set up PostgresSQL in Redhat 9 on a separate machine.  I am
developing a VB.NET app that will read and write to the database, but I
need some guidance in setting up the server.  I'm fairly new to remote
DB stuff (and DB in general).  What specific steps do I need to do to
set up the server (I have PostgreSQL installed and running).  I just
need to know how to access it.

Part of the problem I'm having is that I upgraded my PostgreSQL 7.3.2
to 8.0.2 on the Redhat 9 server, but some of the components
(postmaster, psql) are still thinking it's 7.3.2, so I get an error
when I try to start the server that says "FATAL:  'listen_addresses' is
not a valid option name".  So the 7.3.2 postmaster is reading the 8.0.2
pg_hba.conf file.  I changed the directory when I upgraded from
/var/lib/pgsql/data to /usr/local/pgsql/data.  Don't know if that makes
any difference.  What did I miss on the upgrade?

MSN Messenger:  " milkmood (at) qwest.net "  if you get time.

Thanks,
CP