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.

Close

2967:14173 --

PostgreSQL
omfgppc
2008-11-13
2013-03-08
  • omfgppc
    omfgppc
    2008-11-13

    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:

    http://www.postgresql.org/docs/8.3/interactive/client-authentication.html

    and client access parameters in the postgresql.conf file are described here:

    http://www.postgresql.org/docs/8.3/interactive/runtime-config-connection.html

    Hope this is what you needed.

    Gil -- Read more at http://www.xtuple.org/phpBB2/viewtopic.php?t=2967