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