On Tue, 2012-03-20 at 09:22 -0500, Sam Loy wrote: > 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…
unix_socket_directory=/var/pgsql_socket vs /tmp/.s.PGSQL.5432 you need to tell psql where the unix socket is located, or you need to configure tcp to be available and use the tcp port to connect -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
