Re: Is it even possible?

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…

On 3/20/2012 9:22 AM, 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…

I'm not a mac user, but I'll try.

The server is using unix socket:
-c unix_socket_directory=/var/pgsql_socket

The client (psql) using looking:
> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

You can try using tcp/ip instead by passing -h localhost:

psql -U postgres -h localhost someDbName

-Andy

Sam,

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

I haven't installed PostGIS, but I have no problems running the database in
Lion using the EnterpriseDB (EDB) installer as provided.

> Is there a way to purge my system of all of the corrupted/bad installs and
> start over? How?

I can't speak for Homebrew, but running the included uninstaller safely
removes the EDB pieces.

> 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?

You are not alone -- and I thought I felt strongly about it. :)

--
Gary Chambers

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

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

> Is there anyone who has ever successfully gotten postgres/postGIS running on Mac Lion? Really? How?

Hello Sam,

I'm running Lion, and had the same trouble using the Enterprise Stack Builder to install PostGIS. I finally got it working by using Kyng Chaos' installers for both PostgreSQL and PostGIS:
http://www.kyngchaos.com/software/postgres

Bryan

Looks promising. Does anyone know if you install tpostgres using the postgres EDB before using Kyng Chaos'. Im not sure of the process…

Thanks,

Sam
On Mar 20, 2012, at 3:16 PM, Bryan Lee Nuse wrote:

>> Is there anyone who has ever successfully gotten postgres/postGIS running on Mac Lion? Really? How?
>
> Hello Sam,
>
> I'm running Lion, and had the same trouble using the Enterprise Stack Builder to install PostGIS. I finally got it working by using Kyng Chaos' installers for both PostgreSQL and PostGIS:
> http://www.kyngchaos.com/software/postgres
>
>
> Bryan

Beautiful.

First I installed the framework's described in Kyng Chaos Readme/website for PROJ and GEOS, required by PostGIS.

Then, I installed postgresql using the official postgres 9.1.3 installer, but made the data directory /usr/local/pgsql-9.1/data, instead of the default /Library/etc…., because Kyng Chaos's install expects the data to be there.

That failed on db initialization, but gave me pgadminIII, which is important to me.

Then I ran Kyng Chaos' 9.1.2 installer, which worked flawlessly.

Then I re-ran the pg 9.1.3. It now detected an existing installation, but not data directory. Again, I pointed it to /usr/local/pgsql-9.1/data, which it immediately recognized. This time, the installer ran to completion w/o error, but I finished it w/o running Stack builder.

Then I installed Kyng Chaos' PostGIS 1.5.3 installer, which worked flawlessly, and created a postgis database following the instructions in the README. Worked without a hitch!

Then I loaded up the data I care about…and now I am UP AND RUNNING!

Thanks, Bryan, et.al. Great help. I hope to be able to help others as you have helped me!

With sincere gratitude,

Sam

P.S. So long Winwoes! So long confused MS / \ and command line nav commands!

On Mar 20, 2012, at 3:16 PM, Bryan Lee Nuse wrote:

>> Is there anyone who has ever successfully gotten postgres/postGIS running on Mac Lion? Really? How?
>
> Hello Sam,
>
> I'm running Lion, and had the same trouble using the Enterprise Stack Builder to install PostGIS. I finally got it working by using Kyng Chaos' installers for both PostgreSQL and PostGIS:
> http://www.kyngchaos.com/software/postgres
>
>
> Bryan