Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 240B5358049 for ; Sat, 28 Apr 2012 16:59:40 -0300 (ADT) Received: from nk11p00mm-asmtp001.mac.com ([17.158.161.0]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SODnq-000758-So for pgsql-admin@postgresql.org; Sat, 28 Apr 2012 19:59:39 +0000 MIME-version: 1.0 Content-type: multipart/alternative; boundary="Boundary_(ID_mYZ3CemHN5wRsUav2EaZJQ)" Received: from nk11p00mm-spool004.mac.com ([17.158.161.119]) by nk11p00mm-asmtp001.mac.com (Oracle Communications Messaging Server 7u4-23.01(7.0.4.23.0) 64bit (built Aug 10 2011)) with ESMTP id <0M3700E9YGT4GT70@nk11p00mm-asmtp001.mac.com> for pgsql-admin@postgresql.org; Sat, 28 Apr 2012 19:59:18 +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_06: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-1204280238 Received: from localhost ([17.158.42.223]) by nk11p00mm-spool004.mac.com (Oracle Communications Messaging Server 7u4-23.01(7.0.4.23.0) 64bit (built Aug 10 2011)) with ESMTP id <0M37003FBGU060D0@nk11p00mm-spool004.mac.com> for pgsql-admin@postgresql.org; Sat, 28 Apr 2012 19:58:48 +0000 (GMT) To: pgsql-admin@postgresql.org From: Andrew Barinov Subject: Re: Configuring pg on os x lion Date: Sat, 28 Apr 2012 19:58:48 +0000 (GMT) X-Mailer: MobileMe Mail (1I09.7849) X-Originating-IP: [71.204.133.153] Message-id: <95b02fd2-6335-e1c0-eded-9086337e1f5d@me.com> In-reply-to: X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201204/150 X-Sequence-Number: 39486 --Boundary_(ID_mYZ3CemHN5wRsUav2EaZJQ) Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: quoted-printable 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_mYZ3CemHN5wRsUav2EaZJQ) Content-Type: text/html; CHARSET=US-ASCII Content-Transfer-Encoding: quoted-printable
Hi,

Sure, here are the results fr= om the two commands:

BINDIR =3D /u= sr/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/sha= re/doc/postgresql
PKG= INCLUDEDIR =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/C= ellar/postgresql/9.1.3/lib
PKGLIBDIR =3D /usr/local/Cellar/postgresql/9.1.3/l= ib
LOCALEDIR =3D /usr/local/Cellar/postgresql/9.1.3/share/locale
=
MANDIR =3D /us= r/local/Cellar/postgresql/9.1.3/share/man
SHAREDIR =3D /usr/local/Cellar/post= gresql/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/pgx= s.mk
CC =3D /usr/bin/llvm-gcc
CPPFLA= GS =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/u= sr/local/Cellar/ossp-uuid/1.6.2/include -Wall -Wmissing-prototypes -Wpointe= r-arith -Wdeclaration-after-statement -Wendif-labels -Wformat-security -fno= -strict-aliasing -fwrapv
CFLAGS_SL =3D 
LDFLAGS =3D -L/usr/local/Cellar/re= adline/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 -lssl -lcrypto -lgssapi_krb5 -lz -lreadline -lm -luuid
VERSION= =3D PostgreSQL 9.1.3

larson:~ larson$ /usr/local/C= ellar/postgresql/9.1.3/bin/pg_ctl -D /user/local/var/postgres status=
pg_ctl: = no server running

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

larson:~ larson$ ps -a | grep pos= tgres
17476 tty= s001    0:00.12 postgres -D /usr/local/var/postgres
17543 ttys002    0= :00.00 grep postgres

On a final note when I try= to run psql I get the following result:

larson:~ larson$ psql
<= div style=3D"font-family: 'courier new', monospace; ">psql: FATAL:  da= tabase "larson" does not exist
Thanks,
Andrew
On Apr 27, 2012, at 09:51 PM, raghu ram <r= aghuchennuru@gmail.com> wrote:



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

I am trying to get pg working on os x lion and getti= ng 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 a=
nd try to run postgres directly. When I do I get this:
larson:~ larson$ /usr/l=
ocal/Cellar/postgresql/9.1.3/bin/postgres ; exit; postgres does not know wh=
ere to find the server configuration file. You must specify the --config-fi=
le or -D invocation option or set the PGDATA environment variable. logout
So my thinking here is t=
hat the config files are missing. I searched for pg_hba.conf file and could=
n't find it. Now I am unsure how to proceed, when I used pg on os x Snow Le=
opard I could go into a ~/Library/Developer/postgresql folder and all my co=
nfig files would be there. There would also be logs I could read to get a b=
etter 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,
Andr=
ew
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_mYZ3CemHN5wRsUav2EaZJQ)--