Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 9D99A358049 for ; Sat, 28 Apr 2012 18:02:38 -0300 (ADT) Received: from nk11p00mm-asmtp010.mac.com ([17.158.161.9]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SOEmp-0005lc-3c for pgsql-admin@postgresql.org; Sat, 28 Apr 2012 21:02:37 +0000 MIME-version: 1.0 Content-type: multipart/alternative; boundary="Boundary_(ID_+xnpAvpDgMQ5KWKpuB07kg)" 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 <0M3700KONJRVEL20@nk11p00mm-asmtp010.mac.com> for pgsql-admin@postgresql.org; Sat, 28 Apr 2012 21:02:20 +0000 (GMT) X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:5.6.7580,1.0.260,0.0.0000 definitions=2012-04-28_07:2012-04-27, 2012-04-28, 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-1204280259 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 <0M3700D3VJRVLAD0@nk11p00mm-spool001.mac.com> for pgsql-admin@postgresql.org; Sat, 28 Apr 2012 21:02:19 +0000 (GMT) To: pgsql-admin@postgresql.org From: Andrew Barinov Subject: Re: Configuring pg on os x lion Date: Sat, 28 Apr 2012 21:02:19 +0000 (GMT) X-Mailer: MobileMe Mail (1I09.7849) X-Originating-IP: [71.204.133.153] Message-id: <350d44e5-dcc8-eb3a-bd57-93db50b39257@me.com> In-reply-to: <95b02fd2-6335-e1c0-eded-9086337e1f5d@me.com> X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201204/151 X-Sequence-Number: 39487 --Boundary_(ID_+xnpAvpDgMQ5KWKpuB07kg) Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: quoted-printable Hi, I'd just like to say that I resolved my issue. Thanks! Andrew On Apr 28, 2012, at 12:58 PM, Andrew Barinov wro= te: Hi, Sure, here are the results from the two commands: larson:~ larson$ /usr/local/Cellar/postgresql/9.1.3/bin/pg_config BINDIR =3D /usr/local/Cellar/postgresql/9.1.3/bin DOCDIR =3D /usr/local/Cellar/postgresql/9.1.3/share/doc/postgresql HTMLDIR =3D /usr/local/Cellar/postgresql/9.1.3/share/doc/postgresql INCLUDEDIR =3D /usr/local/Cellar/postgresql/9.1.3/include PKGINCLUDEDIR =3D /usr/local/Cellar/postgresql/9.1.3/include INCLUDEDIR-SERVER =3D /usr/local/Cellar/postgresql/9.1.3/include/server LIBDIR =3D /usr/local/Cellar/postgresql/9.1.3/lib PKGLIBDIR =3D /usr/local/Cellar/postgresql/9.1.3/lib LOCALEDIR =3D /usr/local/Cellar/postgresql/9.1.3/share/locale MANDIR =3D /usr/local/Cellar/postgresql/9.1.3/share/man SHAREDIR =3D /usr/local/Cellar/postgresql/9.1.3/share/postgresql SYSCONFDIR =3D /usr/local/Cellar/postgresql/9.1.3/etc PGXS =3D /usr/local/Cellar/postgresql/9.1.3/lib/pgxs/src/makefiles/pgxs.mk CONFIGURE =3D '--disable-debug' '--prefix=3D/usr/local/Cellar/postgresql/9.= 1.3' '--datadir=3D/usr/local/Cellar/postgresql/9.1.3/share/postgresql' '--d= ocdir=3D/usr/local/Cellar/postgresql/9.1.3/share/doc/postgresql' '--enable-= thread-safety' '--with-bonjour' '--with-gssapi' '--with-krb5' '--with-opens= sl' '--with-libxml' '--with-libxslt' '--with-ossp-uuid' '--with-python' '--= with-perl' 'ARCHFLAGS=3D'''-arch x86_64'''' 'CC=3D/usr/bin/llvm-gcc' 'CFLAG= S=3D-Os -w -pipe -march=3Dcore2 -msse4 -I/usr/local/Cellar/ossp-uuid/1.6.2/= include' 'LDFLAGS=3D-L/usr/local/Cellar/readline/6.2.2/lib -L/usr/local/Cel= lar/ossp-uuid/1.6.2/lib' 'LIBS=3D-luuid' 'CPPFLAGS=3D-I/usr/local/Cellar/re= adline/6.2.2/include -I/usr/include/libxml2' CC =3D /usr/bin/llvm-gcc CPPFLAGS =3D -I/usr/local/Cellar/readline/6.2.2/include -I/usr/include/libx= ml2 -I/usr/local/include/libxml2 CFLAGS =3D -Os -w -pipe -march=3Dcore2 -msse4 -I/usr/local/Cellar/ossp-uuid= /1.6.2/include -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-aft= er-statement -Wendif-labels -Wformat-security -fno-strict-aliasing -fwrapv CFLAGS_SL =3D=A0 LDFLAGS =3D -L/usr/local/Cellar/readline/6.2.2/lib -L/usr/local/Cellar/ossp= -uuid/1.6.2/lib -L/usr/local/lib -Wl,-dead_strip_dylibs LDFLAGS_EX =3D=A0 LDFLAGS_SL =3D=A0 LIBS =3D -lpgport -lxslt -lxml2 -lssl -lcrypto -lgssapi_krb5 -lz -lreadline= -lm -luuid VERSION =3D PostgreSQL 9.1.3 larson:~ larson$ /usr/local/Cellar/postgresql/9.1.3/bin/pg_ctl -D /user/loc= al/var/postgres status pg_ctl: no server running Even though the result above is "no server running", I am do have a postgre= s server running. larson:~ larson$ ps -a | grep postgres 17476 ttys001 =A0 =A00:00.12 postgres -D /usr/local/var/postgres 17543 ttys002 =A0 =A00:00.00 grep postgres On a final note when I try to run psql I get the following result: larson:~ larson$ psql psql: FATAL: =A0database "larson" does not exist Thanks, Andrew On Apr 27, 2012, at 09:51 PM, raghu ram wrote: On Sat, Apr 28, 2012 at 12:52 AM, Andrew Barinov = wrote: 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 soc= ket "/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; po= stgres does not know where to find the server configuration file. You must = specify the --config-file or -D invocation option or set the PGDATA environ= ment 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 Could you please share below=A0information for=A0troubleshooting this issue: /usr/local/Cellar/postgresql/9.1.3/bin/pg_config /usr/local/Cellar/postgresql/9.1.3/bin/pg_ctl -D stat= us --=20 Thanks & Regards, Raghu Ram EnterpriseDB: http://www.enterprisedb.com --Boundary_(ID_+xnpAvpDgMQ5KWKpuB07kg) Content-Type: text/html; CHARSET=US-ASCII Content-Transfer-Encoding: quoted-printable
Hi,

I'd just like to say that I r= esolved my issue.

Thanks!
Andrew

On Apr 28, 2012, at 12:58 PM= , Andrew Barinov <andy.lauerbarinov@me.com> wrote:

=
Hi,

<= /div>
Sure, here are the results from the two commands:

<= /div>
larson:~ larson$ /usr= /local/Cellar/postgresql/9.1.3/bin/pg_config
BINDIR =3D /usr/local/Cellar/postgresql/9.1.3/b= in
DOCDIR =3D /usr/= local/Cellar/postgresql/9.1.3/share/doc/postgresql
HTMLDIR =3D /usr/local/Cellar/postgresql/9.= 1.3/share/doc/postgresql
INCLUDEDIR =3D /usr/local/Cellar/postgresql/9.1.3/include
PKGINCLUDEDIR =3D /usr/local/C= ellar/postgresql/9.1.3/include
INCLUDEDIR-SERVER =3D /usr/local/Cellar/postgresql/9.1.3/includ= e/server
LIBDIR =3D= /usr/local/Cellar/postgresql/9.1.3/lib
PKGLIBDIR =3D /usr/local/Cellar/postgresql/9.1.3/lib
LOCALEDIR =3D /usr/l= ocal/Cellar/postgresql/9.1.3/share/locale
MANDIR =3D /usr/local/Cellar/postgresql/9.1.3/share/= man
SHAREDIR =3D /u= sr/local/Cellar/postgresql/9.1.3/share/postgresql
SYSCONFDIR =3D /usr/local/Cellar/postgresql/= 9.1.3/etc
PGXS =3D = /usr/local/Cellar/postgresql/9.1.3/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE =3D '--disable-deb= ug' '--prefix=3D/usr/local/Cellar/postgresql/9.1.3' '--datadir=3D/usr/local= /Cellar/postgresql/9.1.3/share/postgresql' '--docdir=3D/usr/local/Cellar/po= stgresql/9.1.3/share/doc/postgresql' '--enable-thread-safety' '--with-bonjo= ur' '--with-gssapi' '--with-krb5' '--with-openssl' '--with-libxml' '--with-= libxslt' '--with-ossp-uuid' '--with-python' '--with-perl' 'ARCHFLAGS=3D'''-= arch x86_64'''' 'CC=3D/usr/bin/llvm-gcc' 'CFLAGS=3D-Os -w -pipe -march=3Dco= re2 -msse4 -I/usr/local/Cellar/ossp-uuid/1.6.2/include' 'LDFLAGS=3D-L/usr/l= ocal/Cellar/readline/6.2.2/lib -L/usr/local/Cellar/ossp-uuid/1.6.2/lib' 'LI= BS=3D-luuid' 'CPPFLAGS=3D-I/usr/local/Cellar/readline/6.2.2/include -I/usr/= include/libxml2'
CC= =3D /usr/bin/llvm-gcc
CPPFLAGS =3D -I/usr/local/Cellar/readline/6.2.2/include -I/usr/include/= libxml2 -I/usr/local/include/libxml2
CFLAGS =3D -Os -w -pipe -march=3Dcore2 -msse4 -I/usr/loca= l/Cellar/ossp-uuid/1.6.2/include -Wall -Wmissing-prototypes -Wpointer-arith= -Wdeclaration-after-statement -Wendif-labels -Wformat-security -fno-strict= -aliasing -fwrapv
C= FLAGS_SL =3D 
= LDFLAGS =3D -L/usr/local/Cellar/readline/6.2.2/lib -L/usr/local/Cellar/ossp= -uuid/1.6.2/lib -L/usr/local/lib -Wl,-dead_strip_dylibs
LDFLAGS_EX =3D 
= LDFLAGS_SL =3D 
LIBS =3D -lpgport -lxslt -lxml2 -l= ssl -lcrypto -lgssapi_krb5 -lz -lreadline -lm -luuid
VERSION =3D PostgreSQL 9.1.3
=

larso= n:~ larson$ /usr/local/Cellar/postgresql/9.1.3/bin/pg_ctl -D /user/local/va= r/postgres status
p= g_ctl: no server running

Even though the result above is "no = server running", I am do have a postgres server running.

la= rson:~ larson$ ps -a | grep postgres
17476 ttys001    0:00.12 postgres -D /usr/local/var/postgres=
17543 ttys002    0:00= .00 grep postgres

On a fin= al note when I try to run psql I get the following result:
larson:~ larson$ psql
psql: FATAL:  database "larson" does not exist
<= pre style=3D"font-family: Helvetica,Arial,sans-serif; font-size: 13px; whit= e-space: pre-wrap" data-mce-style=3D"font-family: Helvetica,Arial,sans-seri= f; font-size: 13px; white-space: pre-wrap;">Thanks,
Andrew
On Apr 27, 2012, at 09:51= PM, raghu ram <raghuchennuru@gmail.com> wrote:

=

On Sat, Apr 28, 2012 at 12:52 AM, Andrew= Barinov <andy.lauerbarinov@me.com<= /a>> wrote:
Hi Everyone,

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

I installed pg via homeb= rew 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 loca=
lly and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
So I go ahead and t=
ry 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 kn=
ow where to find the server configuration file. You must specify the --conf=
ig-file or -D invocation option or set the PGDATA environment variable. log=
out
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 Sn=
ow 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 ge=
t a better idea of what's going. Now those seem to be missing, does anyone =
know where I can find them?
Th=
anks in advance for your help,
Andrew
Could you please share below info= rmation for troubleshooting this issue:

/usr/local/Cellar/postgresql/9.1.3/b= in/pg_config

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

--

Thanks & Regards,

Raghu Ram

EnterpriseD= B: http://www.enterprisedb.com


<= /div>= --Boundary_(ID_+xnpAvpDgMQ5KWKpuB07kg)--