hvanhonacker

Upgrade from PostgreSQL 9.3 to 9.4 on Ubuntu 14.10

Install postgresql-9.4

$ sudo apt-get install postgresql-9.4

Then psql version should be 9.4.x

$ psql --version

hvanhonacker

-- 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)

hvanhonacker

  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