This is an old revision of the document!
Table of Contents
Setting up mAirListDB with PostgreSQL
This article explains how to use PostgreSQL as a backend storage for mAirList.
PostgreSQL is an open source database management system, available for Windows, Linux and other operating systems. Being free of charge, fast and networking-enabled, we recommend to use PostgreSQL as the backend for any networked mAirListDB installation (where two or more mAirList computers or processes will share the same database).
Downloading and Installing PostgreSQL
Windows
Binary packages/installers for Windows are available here: http://www.postgresql.org/download/windows/ (for the actual download, you will be taken to a site called EnterpriseDB)
mAirList needs at least PostgreSQL 8.3 but will work fine with newer versions. You should pick the latest stable version available. As of October 2014, this is PostgreSQL 9.3.5.
The Windows installer includes the graphical administration frontend, pgAdmin III.
Linux
PostgreSQL is available as a package in all major Linux distributions. For Debian/Ubuntu, simply install the postgresql
package:
apt-get install postgresql
The graphical frontend pgAdmin III is also available as a package (pgadmin3
). Most experienced Linux administrators will prefer to use the command line tools though.