Re: Getting PostGIS 1.5.3 working with Postgresql90 (Macports)

From: René Fournier <renefournier(at)gmail(dot)com>
To: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Getting PostGIS 1.5.3 working with Postgresql90 (Macports)
Date: 2011-10-08 02:35:51
Message-ID: A431A43C-852E-401D-83A7-59B6D21140C9@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)elevated-dev(dot)com
> http://www.elevated-dev.com/
> (303) 722-0567 voice
>
>
>
>

Best regards,
René Fournier

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-10-08 05:46:09 Re: select vs cursor/fetch speed disparity
Previous Message John DeSoi 2011-10-08 02:08:01 Re: PostgreSQL consulting companies in the Bay Area