Mixing
How to migrate openproject database from Postgresql v9.4 to v9.6 within a docker installation?
I'm trying to update my OpenProject from v7.0 to v8.0 using the new Docker image.Everything went well till I try to import the database. The new version uses Postgresql v9.6 which is incompatible with the former Postgresql v9.4.
There is a good guide on the OpenProject website on how to migrate to Postgresql v9.6: https://www.openproject.org/operations/upgrading/openproject-postgresql-migration-guide-9-6/ . But it covers only the linux installation.
How is it possible to migrate the OpenProject database from Postgresql v9.4 to v9.6 within docker ?
postgresql docker openproject
asked Nov 19 '18 at 15:54
Sakr
5741617
add a comment |
I'm trying to update my OpenProject from v7.0 to v8.0 using the new Docker image.Everything went well till I try to import the database. The new version uses Postgresql v9.6 which is incompatible with the former Postgresql v9.4.
There is a good guide on the OpenProject website on how to migrate to Postgresql v9.6: https://www.openproject.org/operations/upgrading/openproject-postgresql-migration-guide-9-6/ . But it covers only the linux installation.
How is it possible to migrate the OpenProject database from Postgresql v9.4 to v9.6 within docker ?
postgresql docker openproject
asked Nov 19 '18 at 15:54
Sakr
5741617
add a comment |
I'm trying to update my OpenProject from v7.0 to v8.0 using the new Docker image.Everything went well till I try to import the database. The new version uses Postgresql v9.6 which is incompatible with the former Postgresql v9.4.
There is a good guide on the OpenProject website on how to migrate to Postgresql v9.6: https://www.openproject.org/operations/upgrading/openproject-postgresql-migration-guide-9-6/ . But it covers only the linux installation.
How is it possible to migrate the OpenProject database from Postgresql v9.4 to v9.6 within docker ?
postgresql docker openproject
asked Nov 19 '18 at 15:54
Sakr
5741617
I'm trying to update my OpenProject from v7.0 to v8.0 using the new Docker image.Everything went well till I try to import the database. The new version uses Postgresql v9.6 which is incompatible with the former Postgresql v9.4.
There is a good guide on the OpenProject website on how to migrate to Postgresql v9.6: https://www.openproject.org/operations/upgrading/openproject-postgresql-migration-guide-9-6/ . But it covers only the linux installation.
How is it possible to migrate the OpenProject database from Postgresql v9.4 to v9.6 within docker ?
postgresql docker openproject
postgresql docker openproject
asked Nov 19 '18 at 15:54
Sakr
5741617
asked Nov 19 '18 at 15:54
Sakr
5741617
asked Nov 19 '18 at 15:54
Sakr
5741617
asked Nov 19 '18 at 15:54
Sakr
5741617
asked Nov 19 '18 at 15:54
Sakr
5741617
5741617
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Finally a solution is found. Here are the general steps for the migration:
Create the database backup of the current installation:
- Connect to the old Container v7.0
- Stop the running services, except postgers, via supervisorctl stop < service_name >
- Create the dump of the database with the name "openproject"
- Exit the container and copy the created dump outside it
Restore the database into a the new installation:
- Copy the former created dump inside the new container v8.0
- Connect to the new Container v8.0
- Stop the running services, except postgers, via supervisorctl stop < service_name >
- Connect to the postgresql database server and delete the database "openproject"
- Create a new "openproject" database and assign it to the user "openproject"
- Restore the openproject database using the dump file
- Exit and restart the container
OpenProject system will automatically recognize the old database structure and will migrate the tables to match the new version.
I hope this will help someone
answered Nov 28 '18 at 8:41
Sakr
5741617
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53378320%2fhow-to-migrate-openproject-database-from-postgresql-v9-4-to-v9-6-within-a-docker%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Finally a solution is found. Here are the general steps for the migration:
Create the database backup of the current installation:
- Connect to the old Container v7.0
- Stop the running services, except postgers, via supervisorctl stop < service_name >
- Create the dump of the database with the name "openproject"
- Exit the container and copy the created dump outside it
Restore the database into a the new installation:
- Copy the former created dump inside the new container v8.0
- Connect to the new Container v8.0
- Stop the running services, except postgers, via supervisorctl stop < service_name >
- Connect to the postgresql database server and delete the database "openproject"
- Create a new "openproject" database and assign it to the user "openproject"
- Restore the openproject database using the dump file
- Exit and restart the container
OpenProject system will automatically recognize the old database structure and will migrate the tables to match the new version.
I hope this will help someone
answered Nov 28 '18 at 8:41
Sakr
5741617
add a comment |
Finally a solution is found. Here are the general steps for the migration:
Create the database backup of the current installation:
- Connect to the old Container v7.0
- Stop the running services, except postgers, via supervisorctl stop < service_name >
- Create the dump of the database with the name "openproject"
- Exit the container and copy the created dump outside it
Restore the database into a the new installation:
- Copy the former created dump inside the new container v8.0
- Connect to the new Container v8.0
- Stop the running services, except postgers, via supervisorctl stop < service_name >
- Connect to the postgresql database server and delete the database "openproject"
- Create a new "openproject" database and assign it to the user "openproject"
- Restore the openproject database using the dump file
- Exit and restart the container
OpenProject system will automatically recognize the old database structure and will migrate the tables to match the new version.
I hope this will help someone
answered Nov 28 '18 at 8:41
Sakr
5741617
add a comment |
Finally a solution is found. Here are the general steps for the migration:
Create the database backup of the current installation:
- Connect to the old Container v7.0
- Stop the running services, except postgers, via supervisorctl stop < service_name >
- Create the dump of the database with the name "openproject"
- Exit the container and copy the created dump outside it
Restore the database into a the new installation:
- Copy the former created dump inside the new container v8.0
- Connect to the new Container v8.0
- Stop the running services, except postgers, via supervisorctl stop < service_name >
- Connect to the postgresql database server and delete the database "openproject"
- Create a new "openproject" database and assign it to the user "openproject"
- Restore the openproject database using the dump file
- Exit and restart the container
OpenProject system will automatically recognize the old database structure and will migrate the tables to match the new version.
I hope this will help someone
answered Nov 28 '18 at 8:41
Sakr
5741617
Finally a solution is found. Here are the general steps for the migration:
Create the database backup of the current installation:
- Connect to the old Container v7.0
- Stop the running services, except postgers, via supervisorctl stop < service_name >
- Create the dump of the database with the name "openproject"
- Exit the container and copy the created dump outside it
Restore the database into a the new installation:
- Copy the former created dump inside the new container v8.0
- Connect to the new Container v8.0
- Stop the running services, except postgers, via supervisorctl stop < service_name >
- Connect to the postgresql database server and delete the database "openproject"
- Create a new "openproject" database and assign it to the user "openproject"
- Restore the openproject database using the dump file
- Exit and restart the container
OpenProject system will automatically recognize the old database structure and will migrate the tables to match the new version.
I hope this will help someone
answered Nov 28 '18 at 8:41
Sakr
5741617
answered Nov 28 '18 at 8:41
Sakr
5741617
answered Nov 28 '18 at 8:41
Sakr
5741617
answered Nov 28 '18 at 8:41
Sakr
5741617
5741617
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53378320%2fhow-to-migrate-openproject-database-from-postgresql-v9-4-to-v9-6-within-a-docker%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
