* 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
More stories by this author