Clank will need to support (and install) 9.4 postgresql about clank HOT 10 CLOSED

Clank should also uninstall 9.3 or explicitly stop all postgresql services and then explicitly start the selected version of postgresql to ensure atmosphere app does not fail to make migrations dependent on postgresql >9.3

from clank.

Two edge cases right
If clank is running on ubuntu 14.04

1. install postgresql 9.4 if fresh install
2. shutdown 9.3, install 9.4 and upgrade cluster(s)

https://medium.com/@tk512/upgrading-postgresql-from-9-3-to-9-4-on-ubuntu-14-04-lts-2b4ddcd26535#.9t9fkpl4u

from clank.

I think we want to look at going from 9.3 to 9.5.

Which is noted in that 9.3 to 9.4 article: https://medium.com/@tk512/upgrading-postgresql-from-9-4-to-9-5-on-ubuntu-14-04-lts-dfd93773d4a5#.hee4l9mjy

from clank.

Note - we do not use pg in a clustered scenario ... our upgrade / migration steps will be slightly different:

• https://www.postgresql.org/docs/current/static/release-9-4.html
• https://www.postgresql.org/docs/current/static/release-9-5.html

from clank.

In the spirit of reuse, I have found an example of updating from pg 9.1 to 9.4.

from clank.

#92 addresses just including the PostgreSQL Apt repository.

We still need to consider automating the upgrade portion to consider this resolved.

from clank.

So, I have been out of the Postgres game for a couple of years. I was confused about pg_upgrade versus pg_upgradecluster. I didn't find too much info about the difference between the two, just that most "guides" favor pg_upgradecluster (like the one linked above).

So, pg_upgradecluster is one of several cluster tools included in the postgresql-common packages that we are installing in all deployed environments.

Listing the cluster is one thing you get as well:

vagrant@vagrant-ubuntu-trusty-64:~$ pg_lsclusters 
Ver Cluster Port Status Owner    Data directory               Log file
9.3 main    5432 online postgres /var/lib/postgresql/9.3/main /var/log/postgresql/postgresql-9.3-main.log

So - whatever is done in Ansible, using pg_upgradecluster is the path of least resistance!

from clank.

Clank now supports upgrading to PostgreSQL 9.5 (or a target pg_version).

from clank.

Considered fixed by #98.

from clank.

Note, postgresql-common is a Debian package: https://github.com/jbq/postgresql-common

from clank.