Install postgresql-9.4
$ sudo apt-get install postgresql-9.4
Then psql version should be 9.4.x
$ psql --version
| -- Finding the largest databases in your cluster | |
| SELECT d.datname AS Name, pg_catalog.pg_get_userbyid(d.datdba) AS Owner, | |
| CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT') | |
| THEN pg_catalog.pg_size_pretty(pg_catalog.pg_database_size(d.datname)) | |
| ELSE 'No Access' | |
| END AS Size | |
| FROM pg_catalog.pg_database d | |
| ORDER BY | |
| CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT') | |
| THEN pg_catalog.pg_database_size(d.datname) |
| namespace :qc do | |
| desc "start queue classic" | |
| task :start do | |
| run "nohup sh #{current_path}/qc_worker start > /dev/null 2>&1 &" | |
| end | |
| desc "stop queue classic" | |
| task :stop do | |
| run "sh #{current_path}/qc_worker stop" | |
| end |