Comments (5)
No there isnβt one, an issue is opened about upgrades between major version of PG when using the docker image: docker-library/postgres#37
One way to do it I think is this:
- stop your dokku applications
- dump all your databases then destroy them
- stop the PG container then destroy it
- delete the
~dokku/.psql-sc
directory - change the base image for the plugin to PG 9.4
- start the new PG container
- recreate databases for your applications
- restore your databases from your dumps
So beware and backup your data! π
from dokku-psql-single-container.
I'll sneak this other question in here if you don't mind, since it's related:
PG stores its data inside the container, right? So if the image restarts, there's a chance of losing the data? I'm not clear on whether or not data persists during restarts. http://stackoverflow.com/questions/19585028/i-lose-my-data-when-the-container-exits made me a little worried :) I ask because it would be good to know if you risk data loss if the image is restarted (perhaps as part of upgrading the plugin) or if the host system restarts (perhaps due to maintenance).
from dokku-psql-single-container.
Tried running a DB backup, then rebooting my host system. No data loss, so I guess that answers it :) For plugin upgrades I guess it's a good idea to do a backup first anyway, so that's less of a worry.
from dokku-psql-single-container.
yes data are stored outside of the container (~dokku/.psql-sc/data
by default).
from dokku-psql-single-container.
@Flink Oh, that's great. Thank you!
from dokku-psql-single-container.
Related Issues (20)
- How to expose postgresql container to public? HOT 9
- Linking a db container with multiple app containers HOT 8
- Continuous archiving? HOT 4
- Add helpful error on "dokku psql:restore x y.dump" without "<" HOT 4
- "dokku psql:dumpall" for backups HOT 3
- Not all pg_dump output formats supported by psql:restore HOT 5
- Consider deprecating HOT 9
- Errors for psql plugin while listing all plugins HOT 4
- How can I pass --data-only --table when doing a dump? HOT 6
- error when restoring into an app with a slightly different name HOT 3
- can't pgadmin into the database HOT 4
- Where to find password for psql:admin_console or how can I reset it? HOT 2
- dokku 0.5.x help gets corrupted by this plugin HOT 1
- Can't list databases, asks for password
- No data provided on stdin. HOT 3
- dokku 0.3.17 deb's postinst changes owner of /home/dokku/.psql-sc/data HOT 2
- dump command waits for enter HOT 4
- Database creation failed: role does not exist HOT 2
- Feature: Configure PSQL_ROOT in ENV HOT 3
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 dokku-psql-single-container.