django 2.1 + PostgreSQL 11 + Python 3.7 - Cannot do makemigrations The 2019 Stack Overflow Developer Survey Results Are InPostgis / Geodjango: Cannot determine PostGIS version for databaseMy PostGIS database looks fine but GeoDjango thinks otherwise… why?setting up PostgreSQL with django projectHow to connect to multiple PostgreSQL schemas from Django?Django Migrations Says Database Backend Isn't AvailablePostgis isn't an available database backendunable to runserver in django 1.10.1 due to database connectionUnicodeEncodeError during GeoDjango tutorial documentaionDjango won't connect to remote RDSdjango postgres password authentication failed
What does ひと匙 mean in this manga and has it been used colloquially?
Is bread bad for ducks?
What did it mean to "align" a radio?
Does the shape of a die affect the probability of a number being rolled?
How to support a colleague who finds meetings extremely tiring?
Where to refill my bottle in India?
Worn-tile Scrabble
How to save as into a customized destination on macOS?
Multiply Two Integer Polynomials
"as much details as you can remember"
Shouldn't "much" here be used instead of "more"?
Why hard-Brexiteers don't insist on a hard border to prevent illegal immigration after Brexit?
The difference between dialogue marks
What could be the right powersource for 15 seconds lifespan disposable giant chainsaw?
Why not us interferometry to take a picture of Pluto?
Can one be advised by a professor who is very far away?
Am I thawing this London Broil safely?
Identify boardgame from Big movie
Time travel alters history but people keep saying nothing's changed
Why did Acorn's A3000 have red function keys?
What does Linus Torvalds mean when he says that Git "never ever" tracks a file?
FPGA - DIY Programming
STM32 programming and BOOT0 pin
How to deal with fear of taking dependencies
django 2.1 + PostgreSQL 11 + Python 3.7 - Cannot do makemigrations
The 2019 Stack Overflow Developer Survey Results Are InPostgis / Geodjango: Cannot determine PostGIS version for databaseMy PostGIS database looks fine but GeoDjango thinks otherwise… why?setting up PostgreSQL with django projectHow to connect to multiple PostgreSQL schemas from Django?Django Migrations Says Database Backend Isn't AvailablePostgis isn't an available database backendunable to runserver in django 1.10.1 due to database connectionUnicodeEncodeError during GeoDjango tutorial documentaionDjango won't connect to remote RDSdjango postgres password authentication failed
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I'm trying to create a geospatial database with geodjango and postgis following the recommendations of the book : Python Geospatial development, 3rd Edition of Erik Westra, in order to do it I'm trying to configure my django database and to connect it to my PostgreSQL db.
After having launched my PostgreSQL database, I've created my django project and django apps. From then I'd like to apply makemigrations command to my shared app with :
python manage.py makemigrations shared
But then I've go the following error :
File "C:Users[...]Anaconda3libsite-packagespsycopg2__init__.py", line 130, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
django.db.utils.OperationalError
I've even tried to check migrations with showmigrations but it makes the same error message so I've absolutely no clue what's going on.
here's my settings.py file:
DATABASES =
'default':
'ENGINE': 'django.contrib.gis.db.backends.postgis',
'NAME': 'shapeeditor',
'USER': 'shapeeditor',
'PASSWORD': '(password)',
I've put (password) to hide the real one but I've checked it's the good one.
The NAME corresponds to the database name with a USER who has the same name
The shared app is written in INSTALLED_APPS so I've checked I didn't forget it.
I've looked at the many posts in StackOverflow about the error I got but it doesn't correspond to what I've facing here
django python-3.x postgresql postgis geodjango
add a comment |
I'm trying to create a geospatial database with geodjango and postgis following the recommendations of the book : Python Geospatial development, 3rd Edition of Erik Westra, in order to do it I'm trying to configure my django database and to connect it to my PostgreSQL db.
After having launched my PostgreSQL database, I've created my django project and django apps. From then I'd like to apply makemigrations command to my shared app with :
python manage.py makemigrations shared
But then I've go the following error :
File "C:Users[...]Anaconda3libsite-packagespsycopg2__init__.py", line 130, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
django.db.utils.OperationalError
I've even tried to check migrations with showmigrations but it makes the same error message so I've absolutely no clue what's going on.
here's my settings.py file:
DATABASES =
'default':
'ENGINE': 'django.contrib.gis.db.backends.postgis',
'NAME': 'shapeeditor',
'USER': 'shapeeditor',
'PASSWORD': '(password)',
I've put (password) to hide the real one but I've checked it's the good one.
The NAME corresponds to the database name with a USER who has the same name
The shared app is written in INSTALLED_APPS so I've checked I didn't forget it.
I've looked at the many posts in StackOverflow about the error I got but it doesn't correspond to what I've facing here
django python-3.x postgresql postgis geodjango
Are you sure your postgres is up and running? Can you connect to it using other means, likepsqlfrom command line?
– gonczor
Mar 8 at 9:26
I do, I can connect withpsql -U postgres shapeeditorand it seems to work, I have a command line to do queries likeshapeeditor=#
– Rickantonais
Mar 8 at 9:31
The only thing that I can suggest is addingHOSTandPORTsettings.
– gonczor
Mar 8 at 9:34
1
yes I've tried it too but it didn't add more to migration problem, I've just found out I had a privilege issue with my usershapeeditor... Thank you for your time!
– Rickantonais
Mar 8 at 9:42
add a comment |
I'm trying to create a geospatial database with geodjango and postgis following the recommendations of the book : Python Geospatial development, 3rd Edition of Erik Westra, in order to do it I'm trying to configure my django database and to connect it to my PostgreSQL db.
After having launched my PostgreSQL database, I've created my django project and django apps. From then I'd like to apply makemigrations command to my shared app with :
python manage.py makemigrations shared
But then I've go the following error :
File "C:Users[...]Anaconda3libsite-packagespsycopg2__init__.py", line 130, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
django.db.utils.OperationalError
I've even tried to check migrations with showmigrations but it makes the same error message so I've absolutely no clue what's going on.
here's my settings.py file:
DATABASES =
'default':
'ENGINE': 'django.contrib.gis.db.backends.postgis',
'NAME': 'shapeeditor',
'USER': 'shapeeditor',
'PASSWORD': '(password)',
I've put (password) to hide the real one but I've checked it's the good one.
The NAME corresponds to the database name with a USER who has the same name
The shared app is written in INSTALLED_APPS so I've checked I didn't forget it.
I've looked at the many posts in StackOverflow about the error I got but it doesn't correspond to what I've facing here
django python-3.x postgresql postgis geodjango
I'm trying to create a geospatial database with geodjango and postgis following the recommendations of the book : Python Geospatial development, 3rd Edition of Erik Westra, in order to do it I'm trying to configure my django database and to connect it to my PostgreSQL db.
After having launched my PostgreSQL database, I've created my django project and django apps. From then I'd like to apply makemigrations command to my shared app with :
python manage.py makemigrations shared
But then I've go the following error :
File "C:Users[...]Anaconda3libsite-packagespsycopg2__init__.py", line 130, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
django.db.utils.OperationalError
I've even tried to check migrations with showmigrations but it makes the same error message so I've absolutely no clue what's going on.
here's my settings.py file:
DATABASES =
'default':
'ENGINE': 'django.contrib.gis.db.backends.postgis',
'NAME': 'shapeeditor',
'USER': 'shapeeditor',
'PASSWORD': '(password)',
I've put (password) to hide the real one but I've checked it's the good one.
The NAME corresponds to the database name with a USER who has the same name
The shared app is written in INSTALLED_APPS so I've checked I didn't forget it.
I've looked at the many posts in StackOverflow about the error I got but it doesn't correspond to what I've facing here
django python-3.x postgresql postgis geodjango
django python-3.x postgresql postgis geodjango
asked Mar 8 at 9:20
RickantonaisRickantonais
286
286
Are you sure your postgres is up and running? Can you connect to it using other means, likepsqlfrom command line?
– gonczor
Mar 8 at 9:26
I do, I can connect withpsql -U postgres shapeeditorand it seems to work, I have a command line to do queries likeshapeeditor=#
– Rickantonais
Mar 8 at 9:31
The only thing that I can suggest is addingHOSTandPORTsettings.
– gonczor
Mar 8 at 9:34
1
yes I've tried it too but it didn't add more to migration problem, I've just found out I had a privilege issue with my usershapeeditor... Thank you for your time!
– Rickantonais
Mar 8 at 9:42
add a comment |
Are you sure your postgres is up and running? Can you connect to it using other means, likepsqlfrom command line?
– gonczor
Mar 8 at 9:26
I do, I can connect withpsql -U postgres shapeeditorand it seems to work, I have a command line to do queries likeshapeeditor=#
– Rickantonais
Mar 8 at 9:31
The only thing that I can suggest is addingHOSTandPORTsettings.
– gonczor
Mar 8 at 9:34
1
yes I've tried it too but it didn't add more to migration problem, I've just found out I had a privilege issue with my usershapeeditor... Thank you for your time!
– Rickantonais
Mar 8 at 9:42
Are you sure your postgres is up and running? Can you connect to it using other means, like
psql from command line?– gonczor
Mar 8 at 9:26
Are you sure your postgres is up and running? Can you connect to it using other means, like
psql from command line?– gonczor
Mar 8 at 9:26
I do, I can connect with
psql -U postgres shapeeditor and it seems to work, I have a command line to do queries like shapeeditor=#– Rickantonais
Mar 8 at 9:31
I do, I can connect with
psql -U postgres shapeeditor and it seems to work, I have a command line to do queries like shapeeditor=#– Rickantonais
Mar 8 at 9:31
The only thing that I can suggest is adding
HOST and PORT settings.– gonczor
Mar 8 at 9:34
The only thing that I can suggest is adding
HOST and PORT settings.– gonczor
Mar 8 at 9:34
1
1
yes I've tried it too but it didn't add more to migration problem, I've just found out I had a privilege issue with my user
shapeeditor... Thank you for your time!– Rickantonais
Mar 8 at 9:42
yes I've tried it too but it didn't add more to migration problem, I've just found out I had a privilege issue with my user
shapeeditor... Thank you for your time!– Rickantonais
Mar 8 at 9:42
add a comment |
1 Answer
1
active
oldest
votes
After writing my own question I've found where it bugged...
my USER shapeeditor didn't have the privileges, so it couldn't work, just switched with postgres and I worked, I'll have to change privileges in order to make it work
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%2f55060080%2fdjango-2-1-postgresql-11-python-3-7-cannot-do-makemigrations%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 writing my own question I've found where it bugged...
my USER shapeeditor didn't have the privileges, so it couldn't work, just switched with postgres and I worked, I'll have to change privileges in order to make it work
add a comment |
After writing my own question I've found where it bugged...
my USER shapeeditor didn't have the privileges, so it couldn't work, just switched with postgres and I worked, I'll have to change privileges in order to make it work
add a comment |
After writing my own question I've found where it bugged...
my USER shapeeditor didn't have the privileges, so it couldn't work, just switched with postgres and I worked, I'll have to change privileges in order to make it work
After writing my own question I've found where it bugged...
my USER shapeeditor didn't have the privileges, so it couldn't work, just switched with postgres and I worked, I'll have to change privileges in order to make it work
answered Mar 8 at 9:41
RickantonaisRickantonais
286
286
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.
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%2f55060080%2fdjango-2-1-postgresql-11-python-3-7-cannot-do-makemigrations%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
Are you sure your postgres is up and running? Can you connect to it using other means, like
psqlfrom command line?– gonczor
Mar 8 at 9:26
I do, I can connect with
psql -U postgres shapeeditorand it seems to work, I have a command line to do queries likeshapeeditor=#– Rickantonais
Mar 8 at 9:31
The only thing that I can suggest is adding
HOSTandPORTsettings.– gonczor
Mar 8 at 9:34
1
yes I've tried it too but it didn't add more to migration problem, I've just found out I had a privilege issue with my user
shapeeditor... Thank you for your time!– Rickantonais
Mar 8 at 9:42