[GENERAL] Pg version number format

2013-11-13 Thread Tiziano Valdemarin
Just a brief question: When I need to know the running pg version i do a SELECT version(); and get this output: PostgreSQL 9.3.1, compiled by Visual C++ build 1600, 32-bit but I remember a 4 digit version numbering as 9.3.1-1 I can find this version convention used i.e. on http://www.ubuntuupda

[GENERAL] Detect bin directory

2013-11-04 Thread Tiziano Valdemarin
Hi, i deploy one windows application which uses pg and since i have hundred of customers i wrote an updater (updates are mainly monthly). The updater manage pg upgrades too through uninstall and reinstall if there are major server updates to do. This process needs backup and restore and i recently