Re: Getting PostGIS 1.5.3 working with Postgresql90 (Macports) - Mailing list pgsql-general

From René Fournier
Subject Re: Getting PostGIS 1.5.3 working with Postgresql90 (Macports)
Date
Msg-id A431A43C-852E-401D-83A7-59B6D21140C9@gmail.com
Whole thread Raw
In response to Re: Getting PostGIS 1.5.3 working with Postgresql90 (Macports)  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: Getting PostGIS 1.5.3 working with Postgresql90 (Macports)
List pgsql-general

On 2011-10-07, at 7:58 PM, Scott Ribe wrote:

On Oct 7, 2011, at 7:39 PM, René Fournier wrote:

Plus, I find Macports makes it easy to automate a server build in one script. The problem as I see it isn't Macports but my unfamiliarity with Postgresql.

I think it's both ;-) I tried macports for a couple of things and gave up on it. It works for getting dependencies for certain things. Then one day it doesn't work because you're trying a combination that wasn't accounted for, and you now have no idea how all those things you previously installed are configured…

Sorry, I neglected to say, I have Postgresql running. The problem was the initial means of running it. Unlike the Macports documentation, 

sudo /opt/local/etc/LaunchDaemons/org.macports.postgresql90-server/postgresql90-server.wrapper start

…did the trick. My current problem is figuring out how to get PostGIS integrated/working and/or the template_postgis thing working (since it appears I need that to create spatial databases).


But if you can find the pg log, it will usually pretty explicitly tell you why the server is quitting on launch. So you might just need to read those wrapper scripts to see how exactly they invoke postgres.

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice





Best regards,
René Fournier

pgsql-general by date:

Previous
From: John DeSoi
Date:
Subject: Re: PostgreSQL consulting companies in the Bay Area
Next
From: Tom Lane
Date:
Subject: Re: select vs cursor/fetch speed disparity