Related Notes: Windows Compile

Initialize the postgresql database cluster

Note these instructions we tested under Windows but apply more or less to Linux/Unix installs as well

—Some stumbling blocks when doing PostGIS make check —

1. You have multiple PostgreSQL installs

1. If you have multiple PostgreSQL installs as is the case if you are a package developer or just testing diligently, the

first thing you want to make sure is that you are testing the right PostgreSQL install.

To do so do the following (where 5434 is the port your test PostgreSQL service is running under, and the path is the path to the postgresql install you are testing:

export PATH="/c/thesrc/pg84/bin:$PATH"

export PGPORT=5434

export PGUSER=postgres

2. Depending on how you did your make install of geos and proj, they might not be located in a place accessible by the PostgreSQL install. For windows users, you want the libgeos-3-1-1.dll, libgeos_c-1.dll,libiconv-2.dll and libproj.dlls to be located in the bin folder of your PostgreSQL install.

3. If make check fails mid-way — it often leaves a dangling postgis_reg. Just drop it if it complains:

dropdb postgis_reg