On 10/08/2011 10:35 AM, René Fournier wrote:
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).
template_postgis is just the "empty" database template PostGIS creates when it is first installed and configured. It's just like template1, but has the PostGIS support functions and schema already installed. It should be created as part of the regular install and configuration process for PostGIS, AFAIK.
I don't use PostGIS or MacOS, so I can't help much with that side...
--
Craig Ringer
