Skip site navigation (1) Skip section navigation (2)

Re: Configuring pg on os x lion

From: raghu ram <raghuchennuru(at)gmail(dot)com>
To: Andrew Barinov <andy(dot)lauerbarinov(at)me(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Configuring pg on os x lion
Date: 2012-04-28 04:51:39
Message-ID: CALnrrJTD-aCKJrjLa+N0J8gMiqWYUHZ=Wh+fz4WCvU3YWu0Syg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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

In response to

Responses

pgsql-admin by date

Next:From: Kevin KempterDate: 2012-04-28 16:10:01
Subject: Postgres shared memory error
Previous:From: Scott MarloweDate: 2012-04-27 20:50:38
Subject: Re: psql: could not connect to server: No route to host

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group