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 |