Search Postgresql Archives

Re: Is it even possible?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Il 20/03/12 15:22, Sam Loy ha scritto:
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"?
Hummmm... are you using the apple psql?
Lion comes with its own copy of psql. I have many problem (access rights) with it.
Try using psql that come with your postgres installation.


Is there anyone who has ever successfully gotten postgres/postGIS running on Mac Lion? Really? How?
I am using (compiling from surce) Postgres 8.4 and postgis 1.5 (latest versions). 8.4 because I have 8.4 on my server.
Compile postgres is a no-problem operation.
Compile postgis is not so easy because it needs some libraries.


Is there a way to purge my system of all of the corrupted/bad installs and start over? How?
I think that depends on you installation, I have all data in /var/database and simply removing that I have a clean system.


How do I get pgadmin if I use homebrew/macports etc?
Maybe that I didn't understand. simply download it from http://www.pgadmin.org/download/macosx.php

Edoardo

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux