Simple patch / update script

Do you need someone to make some patch on PostgreSQL running on Linux and that person is only able to “run script” but otherwise you cannot rely on anything? Try this solution. It is not genius but it is sufficient. PostgreSQL sql file – I use name...

Install PostgreSQL 9.3 on PcBSD 10

It quite simple only with a few small surprises. pgAdmin you can install directly from AppCafe onmyPcBSD PostgreSQL was notpartofAppCafe so I have to use manual install: as root: pkg install postgresql93-server output from installation will show you: to start...

Check PostgreSQL version

This one gives you most comprehensive human readable info: select version(); Result: “PostgreSQL 9.4.1, compiled by Visual C++ build 1800, 64-bit”   This one is very useful in Linux scripts. show server_version_num Result: “90401” Linux...