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;








0















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










share|improve this question






















  • 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











  • The only thing that I can suggest is adding HOST and PORT settings.

    – 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

















0















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










share|improve this question






















  • 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











  • The only thing that I can suggest is adding HOST and PORT settings.

    – 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













0












0








0








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










share|improve this question














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






share|improve this question













share|improve this question











share|improve this question




share|improve this question










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, 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











  • The only thing that I can suggest is adding HOST and PORT settings.

    – 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

















  • 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











  • The only thing that I can suggest is adding HOST and PORT settings.

    – 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
















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












1 Answer
1






active

oldest

votes


















0














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






share|improve this answer























    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
    );



    );













    draft saved

    draft discarded


















    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









    0














    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






    share|improve this answer



























      0














      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






      share|improve this answer

























        0












        0








        0







        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






        share|improve this answer













        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







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Mar 8 at 9:41









        RickantonaisRickantonais

        286




        286





























            draft saved

            draft discarded
















































            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.




            draft saved


            draft discarded














            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





















































            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







            Popular posts from this blog

            AWS Lex not identifying response if by a variable The 2019 Stack Overflow Developer Survey Results Are In Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) The Ask Question Wizard is Live! Data science time! April 2019 and salary with experienceEnforcing custom enumeration in AWS LEX for slot valuesHow to give response based on user response in Amazon Lex?Intercepting AWS Lambda Response to a AWS Lex QueryLex chat bot error: Reached second execution of fulfillment lambda on the same utteranceamazon lex showing invalid responseLambda response send back to Lex slot?Response card in Amazon lexAmazon Lex - Lambda response return HTML to botHow can I solve 424 (Failed Dependency) (python) obtained from Amazon lex?

            Алба-Юлія

            Захаров Федір Захарович