Kyng Chaos
“The beast is actively interested only in now, and, as it is always now and always shall be, there is an eternity of time for the accomplishment of objects.”
- the wisdom of Tarzan

PostgreSQL

Mac OS X installers for PostgreSQL, and GIS extensions PostGIS and pgRouting. Built for Leopard and Snow Leopard.

Postgres 8.4

Postgres 8.3

PostgreSQL itself does not require anything extra, and includes the Pl/Python language (uses the system Python). Initial database setup is done for you if you have never installed Postgres before.

The PostgreSQL Client does not include the server. This is handy if you just need to connect to another computer that is running a Postgres server. Also included are the client libraries and headers, so developers don't have to install the full Postgres to add Postgres support to their software. The full Postgres package includes Postgres Client, so there is no need to install the client if you already installed the server.

The PostGIS extension requires the GEOS 3 and PROJ frameworks. The pgRouting extension does not require anything extra, though it can use PostGIS. All extensions require the Postgres server and won't function with the client-only package.

Upgrades

Because of the many changes at once with Postgres 8.3-8.4, PostGIS 1.3-1.4 and Snow Leopard, here is a recommended order of updates:

  1. PostGIS to 1.4 (see update notes in readme)
  2. Dump (see the Postgres Upgrade readme)
  3. System to Snow Leopard
  4. Postgres to 8.4
  5. Restore (see the Postgres Upgrade readme)

* PostGIS 1.3 for Postgres 8.4 is a convenience is case you've updated to Postgres 8.4 before updating PostGIS databases to 1.3, and is for Leopard only.

Notes

NOTE: I've had reports of the installer not initializing the data cluster, which results in Postgres not starting. It seems to be random, and I haven't figured out the cause yet. If Postgres won't start (you get an error "could not connect to server: No such file or directory" when trying to connect with psql), try manually initializing the cluster with:

sudo su - postgres -c "/usr/local/pgsql/bin/initdb \
-D /usr/local/pgsql/data --encoding=UTF8 --locale=en_US"

Or see the Locales and Encodings readme if you need a different locale or encoding.

Then stop and start Postgres as specified in the readme.

Panther & Tiger

For Postgres and extras to run on Panther & Tiger, see the build notes:

software/postgres.txt (11380 views) · Last modified: 2010/01/10 08:38 by kyngchaos
Copyright © 2004-2009 William Kyngesburye Driven by DokuWiki Recent changes RSS feed