====== PostgreSQL ======

Built for Tiger and Leopard.

  * {{/files/software/unixport/PostgreSQL-8.3.5-1.dmg|PostgreSQL 8.3.5-1}} [34.2 MB]
  * {{/files/software/unixport/PostGIS-1.3.3-1a.dmg|PostGIS 1.3.3-1a}} [1.5 MB]
  * {{/files/software/unixport/pgRouting-1.0.1-4.dmg|pgRouting 1.0.1-4}} [1.9 MB]

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

The PostGIS extension requires the **GEOS 3** and **PROJ** [[frameworks|frameworks]]. The pgRouting extension does not require anything extra, though it can use PostGIS. All extensions require the Postgres server.

<box 100%>
**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:

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

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.
</box>

/*
The R package does NOT need to have Postgres installed, uness you are accessing local Postgres DBs.
*/

===== Old 8.2 =====

Built for Tiger and Leopard.

  * {{/files/software/unixport/PostgreSQL-8.2.6-2.dmg|PostgreSQL 8.2.6-2}} [24.1 MB]
  * {{/files/software/unixport/postgis-1.3.2-2.dmg|PostGIS 1.3.2-2}} [1.5 MB]
  * {{/files/software/unixport/pgRouting-1.0.1-3.dmg|pgRouting 1.0.1-3}} [1.9 MB]

Same requirements as 8.3.

===== Panther =====

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

  * [[macosx:build:postgresql|Postgres]]
  * [[macosx:build:postgis|PostGIS]]
  * [[macosx:build:pgrouting|pgRouting]]
  * [[macosx:build:postgresr|RdbiPgSQL]]