Is it even possible? - Mailing list pgsql-general

From Sam Loy
Subject Is it even possible?
Date
Msg-id 701EF75B-F5FA-4C96-9D5C-65DE6163BDF9@gmail.com
Whole thread Raw
Responses Re: Is it even possible?  (Andy Colson <andy@squeakycode.net>)
Re: Is it even possible?  (Gary Chambers <gwchamb@gwcmail.com>)
Re: Is it even possible?  (Reid Thompson <Reid.Thompson@ateb.com>)
Re: Is it even possible?  (Edoardo Panfili <edoardo@aspix.it>)
Re: Is it even possible?  (Bryan Lee Nuse <nuse@uga.edu>)
List pgsql-general
I have now tried at least 7 different install methods to get pg up and running on Lion. I fear that my system is now
thoroughlyinoculated and will never be able to run postgres/postgis. 

I started with the pg mac installer / stack builder. That worked to get pg installed, but could not get postgis
installed.

I've now tried two different instructions using MacPort, Two using homebrew, and two using
some-other-macport-homebrew-likemethod. 

NONE of them worked for me. I can see postgress running from the last install:
sameloyiv      39844   0.0  0.1  2455512   6496   ??  S     9:02AM   0:00.12 /usr/local/bin/postgres -D
/usr/local/var/postgres-r /usr/local/var/postgres/server.log -c unix_socket_directory=/var/pgsql_socket -c
unix_socket_group=_postgres-c unix_socket_permissions=0770 
root             104   0.0  0.0  2467372   1140   ??  Ss    4:46PM   0:00.21 /opt/local/bin/daemondo
--label=postgresql91-server--start-cmd
/opt/local/etc/LaunchDaemons/org.macports.postgresql91-server/postgresql91-server.wrapperstart ; --stop-cmd
/opt/local/etc/LaunchDaemons/org.macports.postgresql91-server/postgresql91-server.wrapperstop ; --restart-cmd
/opt/local/etc/LaunchDaemons/org.macports.postgresql91-server/postgresql91-server.wrapperrestart ; --pid=none 
sameloyiv      40075   0.0  0.0  2434892    548 s000  S+    9:17AM   0:00.00 grep post
sameloyiv      39849   0.0  0.0  2441352    384   ??  Ss    9:02AM   0:00.02 postgres: stats collector process
   
sameloyiv      39848   0.0  0.0  2455644   1564   ??  Ss    9:02AM   0:00.02 postgres: autovacuum launcher process
       
sameloyiv      39847   0.0  0.0  2455512    512   ??  Ss    9:02AM   0:00.09 postgres: wal writer process
sameloyiv      39846   0.0  0.0  2455512    604   ??  Ss    9:02AM   0:00.12 postgres: writer process

But continue to see this when using psql:
psql: 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"?

Is there anyone who has ever successfully gotten postgres/postGIS running on Mac Lion? Really? How?
Is there a way to purge my system of all of the corrupted/bad installs and start over? How?

How do I get pgadmin if I use homebrew/macports etc?

Would love to believe this is possible, as I cannot stand having to stop whatever I'm doing every 3-4 days to repair
Windows.I hate Windows. I loath Windows, and would love to see the U.S. Economy rebound from all of the production
gainedby everyone universally abandoning Windows… 

pgsql-general by date:

Previous
From: Chengjie Qin
Date:
Subject: Initialize the User-defined Aggregate in ECPG
Next
From: Andy Colson
Date:
Subject: Re: Is it even possible?