Forum OpenACS Q&A: Re: ODBC-connection to Postgres database
Go into your /usr/local/pgsql/postgresql.conf file and uncomment the connection parameters. I left all as default. Then open the pg_hba.conf file and configure which hosts can connect.
That should do it, I had to modify both to get pgadmin2 to work here...