postgres - pgmodeler installation in ubuntu with source compile

* postgres - pgmodelear

** new version
 > download: https://github.com/pgmodeler/pgmodeler

sudo apt-get install qt-sdk
sudo apt-get install qttools5-dev
sudo apt-get install libpq-dev
sudo apt-get install libxml2-dev

 > compile
:  sudo apt-get install qt4-qmake  <-- actuall qt50qmake use
sudo apt-get install gcc-4.7
sudo apt-get install libqt4-dev
sudo apt-get install xml2
sudo apt-get install libpq5
sudo apt-get install libqp-dev
sudo apt-get install libpq-dev
sudo apt-get install pkg-config

unzip pgmodeler-develop.zip
cd pgmodeler-develop/

qmake -qt=5 pgmodeler.pro
make
make install
sudo make install


No declaration for attribute connect_timeout of element connection sslmode="disable" auto-browse-db="false"/>

> https://github.com/pgmodeler/pgmodeler/issues/829
$ diff -u /usr/local/share/pgmodeler/conf/defaults/connections.conf /usr/local/share/pgmodeler/conf/connections.conf
#+begin_src
--- /usr/local/share/pgmodeler/conf/defaults/connections.conf   2016-04-17 17:02:45.540901204 -0700
+++ /usr/local/share/pgmodeler/conf/connections.conf    2015-12-30 21:58:24.234252027 -0800
@@ -4,7 +4,7 @@
            Unexpected results may occur if the code is changed deliberately.
 -->
 <connections>
-       <connection alias="local-db" host="localhost" port="5432" dbname="postgres"
-               user="postgres" password="postgres" connection-timeout="2"
+       <connection alias="local-db" host="localhost" port="5432" dbname="postgres"
+               user="postgres" password="postgres" connect_timeout="2"
                sslmode="disable" auto-browse-db="false"/>
 </connections>
#+end_src


> https://github.com/pgmodeler/pgmodeler/issues/823
-- vi ~/.config/pgmodeler/connections.conf
#+begin_src
<?xml version="1.0" encoding="UTF-8" ?>
<!--
  CAUTION: Do not modify this file directly on it's code unless you know what you are doing.
           Unexpected results may occur if the code is changed deliberately.
<connections>
        <connection alias="local-db" host="localhost" port="5432" dbname="postgres"
                user="postgres" password="postgres" connect_timeout="2"
                sslmode="disable" auto-browse-db="false"/>
</connections>
-->
<connections>
       <connection alias="local-db" host="localhost" port="5432" dbname="postgres"
               user="postgres" password="postgres" connection-timeout="2"
                sslmode="disable" auto-browse-db="false"/>
</connections>
#+end_src

The file connections.conf changed in the new release (0.8.2-beta1) and if you're upgrading an installation on your machine it's probably that you' re using the old version of the mentioned file.

The solution: look for the file connections.conf in your local settings storage.

    Linux: /home/[user]/.config/pgmodeler
    Windows: C:\User\[user]\AppData\Local\pgmodeler
    Mac OS X: /User/[user]/Library/Preferences/br.com.pgmodeler

Open the file in a text editor and replace any occurrence of connect_timeout by connection-timeout. Start the application again and it should stop to raise the errors.


** add program shortcuts to unity launcher in ubuntu

- from: http://ubuntuforums.org/showthread.php?t=1972410

1. create a text file "pgmodeler.desktop"

-- /home/guo/bin/desktop/pgmodeler.desktop
 > png available from https://avatars1.githubusercontent.com/u/2207918?v=3&s=400


2. run pgmodeler in terminal then quit
 > unitiy launcher icon apper with ? icon


3. change icon or modify
check if ther was created in pgmodeler.desktop
ls -alh ~/.local/share/applications/pgmodeler.desktop
if there is already created file (pgmodeler.desktop) it will like as following.

edit it or create one.

--> from
#+begin_src
[Desktop Entry]
Encoding=UTF-8
Version=1.0
Type=Application
Name=pgModeler - PostgreSQL Database Modeler 0.8.2-beta1
Icon=pgmodeler.png
Path=/usr/local/bin
Exec=pgmodeler
StartupNotify=false
StartupWMClass=pgmodeler
OnlyShowIn=Unity;
X-UnityGenerated=true
#+end_src

--> to
modify as following ~/.local/share/applications/pgmodeler.desktop
#+begin_src
[Desktop Entry]
Name=pgmodeler
Comment=pgmodeler for PostgreSQL
Exec=/usr/local/bin/pgmodeler
TryExec=/usr/local/bin/pgmodeler
Icon=/home/guo/bin/icon/pgmodeler.png
StartupNotify=false
Terminal=false
Type=Application
Categories=Database; Misc
#+end_src

rerun pgmodeler and fix it to the launcher


4. locate file for future restall and backup
sudo updatedb
locate pgmodeler.desktop

~/.gnome/apps/pgmodeler.desktop
~/.local/share/applications/pgmodeler.desktop
~/bin/desktop/pgmodeler.desktop