build PgModeler from source

pgmodeler_logo

PGModeler (http://www.pgmodeler.com.br) is a nice tool to design your (PostgreSQL) database. It supports import from and export to a databases. Ubuntu 15.10 comes with a quite recent version but e.g. Debian does not provide it in the repository. In this post I explain howto build the application on Linux (tested on Debian 8) from source.

Installing needed libraries

To be able compile pgmodeler from source, the following libraries need to be installed:

sudo apt-get install build-essential
sudo apt-get install git
sudo apt-get install qt5-default 
sudo apt-get install qt5-qmake
sudo apt-get install libpq5
sudo apt-get install libxml2
sudo apt-get install pkg-config
sudo apt-get install xml2
sudo apt-get install libxml2-dev
sudo apt-get install libpq-dev

You can also install the same libraries with the following command in one line:

sudo apt-get install build-essential git qt5-default qt5-qmake libpq5 libxml2 pkg-config xml2 libxml2-dev libpq-dev

Both commands will install a bunch of addtional libraries they depend on.

Getting the source

Once the system is prepared, you need to download the source code. You can either download a prepackaged zip archive from https://github.com/pgmodeler/pgmodeler/releases or download the source from the repository hosted on https://github.com/pgmodeler/pgmodeler.git.

To get the files from github, you needed to execute the following commands:

mkdir ~/src
cd ~/src
git clone https://github.com/pgmodeler/pgmodeler.git
cd pgmodeler
git checkout tags/v0.8.2-beta

Build the application

Once everything is prepared, you can compile and install pgmodeler using the following commands

qmake pgmodeler.pro
make
make install

The binary will be available in /usr/local/bin/

Tested with

The above build and install guide has been tested with v0.8.1 and v0.8.2-beta and v0.8.2

Update 2016-07-09 / v0.8.2

For v0.8.2 an addtional library needs to installed:

sudo apt-get install libqt5svg5-dev