Is it even possible?

From: Sam Loy <drtubbygooberman(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Is it even possible?
Date: 2012-03-20 14:22:07
Message-ID: 701EF75B-F5FA-4C96-9D5C-65DE6163BDF9@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 thoroughly inoculated 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-like method.

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.wrapper start ; --stop-cmd /opt/local/etc/LaunchDaemons/org.macports.postgresql91-server/postgresql91-server.wrapper stop ; --restart-cmd /opt/local/etc/LaunchDaemons/org.macports.postgresql91-server/postgresql91-server.wrapper restart ; --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 gained by everyone universally abandoning Windows…

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Reichstadt 2012-03-20 15:28:30 PASSWORD vs. md5('somepass')
Previous Message Tom Lane 2012-03-20 13:58:38 Re: WHERE IN (subselect) versus WHERE IN (1,2,3,)