Re: Configuring pg on os x lion

On Sat, Apr 28, 2012 at 12:52 AM, Andrew Barinov
<andy(dot)lauerbarinov(at)me(dot)com>wrote:

> Hi Everyone,
>
> I am trying to get pg working on os x lion and getting some configuration
> errors. Wondering if anyone on this list faced these before.
>
> I installed pg via homebrew and I get this error when trying to launch it
> via a local web server on my machine:
> could not connect to server: No such file or directory
>
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>
> So I go ahead and try to run postgres directly. When I do I get this:
>
> larson:~ larson$ /usr/local/Cellar/postgresql/9.1.3/bin/postgres ; exit;
> postgres does not know where to find the server configuration file.
> You must specify the --config-file or -D invocation option or set the PGDATA environment variable.
> logout
>
> So my thinking here is that the config files are missing. I searched for pg_hba.conf file and couldn't find it. Now I am unsure how to proceed, when I used pg on os x Snow Leopard I could go into a ~/Library/Developer/postgresql folder and all my config files would be there. There would also be logs I could read to get a better idea of what's going. Now those seem to be missing, does anyone know where I can find them?
>
> Thanks in advance for your help,
>
> Andrew
>
> Could you please share below information for troubleshooting this issue:

/usr/local/Cellar/postgresql/9.1.3/bin/pg_config

/usr/local/Cellar/postgresql/9.1.3/bin/pg_ctl -D <data Directory Path>
status

--

Thanks & Regards,

Raghu Ram

EnterpriseDB: http://www.enterprisedb.com