Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.
gmoskowitz wrote: Steve,
It''s hard to give a clear answer because I don''t know where PostgreSQL is installed on your server, nor where the data directory is for your database (they can be in different places). The most likely location is /usr/local/postgres or /usr/local/pgsql for the installation and /usr/local/[postgres | pgsql]/data for the server-specific directory. These are easiest to reach with Terminal (the Finder likes to hide /usr). If they''re not here then you''ll have to use File -> Find... in the Finder to look for postgresql.conf.
You''ll probably have to muck with both the postgresql.conf and pg_hba.conf files to set up the access rules you desire. ''listen_addresses'' is in the postgresql.conf file. If you haven''t found it yet, the pg_hba.conf is described here:
and client access parameters in the postgresql.conf file are described here:
Hope this is what you needed.
Gil -- Read more at http://www.xtuple.org/phpBB2/viewtopic.php?t=2967