Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 89B7C8A4BA for ; Fri, 27 Apr 2012 16:22:43 -0300 (ADT) Received: from nk11p00mm-asmtp010.mac.com ([17.158.161.9]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SNqkc-0007pN-3u for pgsql-admin@postgresql.org; Fri, 27 Apr 2012 19:22:43 +0000 MIME-version: 1.0 Content-type: multipart/alternative; boundary="Boundary_(ID_gmyfpb/OjdpXV0HTKbD4Ag)" Received: from nk11p00mm-spool001.mac.com ([17.158.161.66]) by nk11p00mm-asmtp010.mac.com (Oracle Communications Messaging Server 7u4-23.01(7.0.4.23.0) 64bit (built Aug 10 2011)) with ESMTP id <0M35009BXKHDEP70@nk11p00mm-asmtp010.mac.com> for pgsql-admin@postgresql.org; Fri, 27 Apr 2012 19:22:26 +0000 (GMT) X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:5.6.7580,1.0.260,0.0.0000 definitions=2012-04-27_03:2012-04-27, 2012-04-27, 1970-01-01 signatures=0 X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 spamscore=0 ipscore=0 suspectscore=1 phishscore=0 bulkscore=0 adultscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=6.0.2-1012030000 definitions=main-1204270233 Received: from localhost ([17.158.42.223]) by nk11p00mm-spool001.mac.com (Oracle Communications Messaging Server 7u4-23.01(7.0.4.23.0) 64bit (built Aug 10 2011)) with ESMTP id <0M3500LS1KHDF520@nk11p00mm-spool001.mac.com> for pgsql-admin@postgresql.org; Fri, 27 Apr 2012 19:22:25 +0000 (GMT) To: pgsql-admin@postgresql.org From: Andrew Barinov Subject: Configuring pg on os x lion Date: Fri, 27 Apr 2012 19:22:25 +0000 (GMT) X-Mailer: MobileMe Mail (1I09.7849) X-Originating-IP: [71.204.133.153] Message-id: <488190a6-e3b2-6d21-b4fe-dbad540f23c0@me.com> X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201204/144 X-Sequence-Number: 39480 --Boundary_(ID_gmyfpb/OjdpXV0HTKbD4Ag) Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: quoted-printable Hi Everyone, I am trying to get pg working on os x lion and getting some configuration e= rrors. Wondering if anyone on this list faced these before. I installed pg via homebrew and I get this error when trying to launch it v= ia a local web server on my machine:=A0 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 PGDAT= A 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/postgre= sql 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 mi= ssing, does anyone know where I can find them? Thanks in advance for your help, Andrew --Boundary_(ID_gmyfpb/OjdpXV0HTKbD4Ag) Content-Type: text/html; CHARSET=US-ASCII Content-Transfer-Encoding: quoted-printable
Hi Everyone,

I am trying to get p= g working on os x lion and getting some configuration errors. Wondering if = anyone on this list faced these before.

I installe= d 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 PGDAT=
A 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 f=
older and all my config files would be there. There would also be logs I co=
uld 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
= --Boundary_(ID_gmyfpb/OjdpXV0HTKbD4Ag)--