Mateusz Loskot

I’ve extended Sean’s idea of baking PostGIS-enabled databases using GNU Make a little bit and prepared new version of Makefile.postgis.

How to use it:

• Install it to save yourself some typing:

  $ ln -s Makefile.postgis Makefile

• Run make to get basic usage information:

  $ make
  ****** Makefile.postgis usage ******
  *** Create new PostGIS database:
  	DBNAME=mydb make -f Makefile.postgis create
  *** Drop PostGIS database:
  	DBNAME=mydb make -f Makefile.postgis drop
  *** Check if database exists and PostGIS if enabled with PostGIS:
  	DBNAME=mydb make -f Makefile.postgis check
  *** Check if database exists:
  	DBNAME=mydb make -f Makefile.postgis check-db
  *** Check if database is enabled with PostGIS:
  	DBNAME=mydb make -f Makefile.postgis check-postgis

• Check if your database exists:

  $ DBNAME=mydb make check-db
  ****** Makefile.postgis ******
  ****** Database 'mydb' not found

• Create your database with PostGIS extension installed:

  $ DBNAME=mydb make create
  ****** Makefile.postgis ******
  ****** Creating database 'mydb'...
  ****** Loading PostGIS into 'mydb'...

• Check what has been created and installed:

  $ DBNAME=mydb make check
  ****** Makefile.postgis ******
  ****** Database 'mydb' found
  ****** Makefile.postgis ******
  ****** Database 'mydb' is enabled with PostGIS
  1.4 USE_GEOS=1 USE_PROJ=1 USE_STATS=1

• When you don’t need your database anymore, just drop it:

  $ DBNAME=mydb make drop

This entry was posted on Thursday, April 9th, 2009 at 11:59 am and is filed under gis, postgis, tools. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.