Comments (10)
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
- install postgresql 9.4 if fresh install
- shutdown 9.3, install 9.4 and upgrade cluster(s)
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.
Related Issues (20)
- Revisit "List of Files Needed" in README
- ImportError: No module named backports.ssl_match_hostname HOT 1
- Run Clank twice in Travis test
- Use `pip-tools` for Clank's requirements HOT 1
- Problem: Troposphere pull requests are created without any build verification
- Clean up travis.yml's postgres install section
- Issues of running 'pip install -r clank/requirements.txt' HOT 3
- Cannot restart atmosphere on Ubuntu 16.04 HOT 2
- Make finer grained backups
- Problem: Atmosphere Django cache directory not writable by www-data HOT 1
- Problem: Configure system `ulimit` (open files) HOT 1
- Run clank with previous release of Atmosphere/Troposphere HOT 7
- Clank on CentOS7 HOT 1
- Create New Relic deployment
- Warn/Error when New Relic is not installed/configured/working HOT 1
- Not picking up the correct repos to clone HOT 1
- Cannot uninstall new relic HOT 7
- app-install-instance-deploy-automation role fails on remote deployment when creating hosts file
- CI test in Different Linux Distros HOT 3
- Default NGINX config breaks http->https redirect
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from clank.