How to migrate from sqlite to postgres
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I already have a django project live on heroku. I am now wanting to migrate the database from sqllite to postgres because of some issues regarding heroku like when I set DEBUG=True, the site runs without any issues but as soon as I set DEBUG to False, I get server error 500. I'd hard time finding any working solution, so I've decided to move to postgres. So, I have changed my settings.py file to have default db as postgres. I don't know about any other change in this file regarding the production settings.Also, I'm on windows machine and have installed postgres, also installed the psycopg2 library.I have created the db manually in postgres.
The issue I'm facing is, as soon as I run makemigrations command, it creates an sqlite db. Why does this happen?
django database postgresql sqlite heroku
asked Jan 4 at 18:35
DaceyDacey
66
add a comment |
I already have a django project live on heroku. I am now wanting to migrate the database from sqllite to postgres because of some issues regarding heroku like when I set DEBUG=True, the site runs without any issues but as soon as I set DEBUG to False, I get server error 500. I'd hard time finding any working solution, so I've decided to move to postgres. So, I have changed my settings.py file to have default db as postgres. I don't know about any other change in this file regarding the production settings.Also, I'm on windows machine and have installed postgres, also installed the psycopg2 library.I have created the db manually in postgres.
The issue I'm facing is, as soon as I run makemigrations command, it creates an sqlite db. Why does this happen?
django database postgresql sqlite heroku
asked Jan 4 at 18:35
DaceyDacey
66
add a comment |
I already have a django project live on heroku. I am now wanting to migrate the database from sqllite to postgres because of some issues regarding heroku like when I set DEBUG=True, the site runs without any issues but as soon as I set DEBUG to False, I get server error 500. I'd hard time finding any working solution, so I've decided to move to postgres. So, I have changed my settings.py file to have default db as postgres. I don't know about any other change in this file regarding the production settings.Also, I'm on windows machine and have installed postgres, also installed the psycopg2 library.I have created the db manually in postgres.
The issue I'm facing is, as soon as I run makemigrations command, it creates an sqlite db. Why does this happen?
django database postgresql sqlite heroku
asked Jan 4 at 18:35
DaceyDacey
66
I already have a django project live on heroku. I am now wanting to migrate the database from sqllite to postgres because of some issues regarding heroku like when I set DEBUG=True, the site runs without any issues but as soon as I set DEBUG to False, I get server error 500. I'd hard time finding any working solution, so I've decided to move to postgres. So, I have changed my settings.py file to have default db as postgres. I don't know about any other change in this file regarding the production settings.Also, I'm on windows machine and have installed postgres, also installed the psycopg2 library.I have created the db manually in postgres.
The issue I'm facing is, as soon as I run makemigrations command, it creates an sqlite db. Why does this happen?
django database postgresql sqlite heroku
django database postgresql sqlite heroku
asked Jan 4 at 18:35
DaceyDacey
66
asked Jan 4 at 18:35
DaceyDacey
66
edited Jan 4 at 19:34
Dacey
asked Jan 4 at 18:35
DaceyDacey
66
asked Jan 4 at 18:35
DaceyDacey
66
asked Jan 4 at 18:35
DaceyDacey
66
66
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
After you have run python manage.py makemigrations you need to run python manage.py migrate to apply the data to the new database.
answered Jan 4 at 20:37
augu1352augu1352
1
done that ofcourse, but it is creating a sqlite db instead of postgres
– Dacey
Jan 5 at 8:14
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%2f54044346%2fhow-to-migrate-from-sqlite-to-postgres%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
After you have run python manage.py makemigrations you need to run python manage.py migrate to apply the data to the new database.
answered Jan 4 at 20:37
augu1352augu1352
1
done that ofcourse, but it is creating a sqlite db instead of postgres
– Dacey
Jan 5 at 8:14
add a comment |
After you have run python manage.py makemigrations you need to run python manage.py migrate to apply the data to the new database.
answered Jan 4 at 20:37
augu1352augu1352
1
done that ofcourse, but it is creating a sqlite db instead of postgres
– Dacey
Jan 5 at 8:14
add a comment |
After you have run python manage.py makemigrations you need to run python manage.py migrate to apply the data to the new database.
answered Jan 4 at 20:37
augu1352augu1352
1
After you have run python manage.py makemigrations you need to run python manage.py migrate to apply the data to the new database.
answered Jan 4 at 20:37
augu1352augu1352
1
answered Jan 4 at 20:37
augu1352augu1352
1
answered Jan 4 at 20:37
augu1352augu1352
1
answered Jan 4 at 20:37
augu1352augu1352
1
1
done that ofcourse, but it is creating a sqlite db instead of postgres
– Dacey
Jan 5 at 8:14
add a comment |
done that ofcourse, but it is creating a sqlite db instead of postgres
– Dacey
Jan 5 at 8:14
done that ofcourse, but it is creating a sqlite db instead of postgres
– Dacey
Jan 5 at 8:14
done that ofcourse, but it is creating a sqlite db instead of postgres
– Dacey
Jan 5 at 8:14
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.
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%2f54044346%2fhow-to-migrate-from-sqlite-to-postgres%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
