Psyopg2[binary] not working | Django | Page 1

fleet olive Dec 24, 2023, 12:56 AM

#

For some reason psycopg[binary] has stopped working. Is there some workaround for this?

I have tried uninstalling it and installing it.

I have checked stack overflow and they tell me to install different ways. I have tried that and it hasn't worked.

Stack Overflow: https://stackoverflow.com/questions/8237842/django-core-exceptions-improperlyconfigured-error-loading-psycopg-module-no-mo

Has something updated?

Error message and pip list output
https://paste.pythondiscord.com/7WRQ
Stack Overflow
django.core.exceptions.ImproperlyConfigured: Error loading psycopg ...
Presently, I'm attempting to configure Django for use on a project, and am encountering a persistent error when I try to run python manage.py syncdb.

File "/x/x/x/x/x/x/base.py", line 23, in ?
...

Stack Overflow

django.core.exceptions.ImproperlyConfigured: Error loading psycopg ...

Presently, I'm attempting to configure Django for use on a project, and am encountering a persistent error when I try to run python manage.py syncdb.

File "/x/x/x/x/x/x/base.py", line 23, in ?
...

analog cypress Dec 24, 2023, 1:05 AM

#

You're running Django version 4.0.10. Psycopg3 support was introduced with version 4.2: https://docs.djangoproject.com/en/5.0/releases/4.2/#what-s-new-in-django-4-2

Either update Django to =>4.2, or downgrade your psycopg to v2

fleet olive Dec 24, 2023, 1:08 AM

#

Django updated!? Ahhhhh thats why

analog cypress Dec 24, 2023, 1:09 AM

#

Fyi, if you want to continue using psycopg2, note that the binary release is only meant for development and isn't considered stable:
https://www.psycopg.org/docs/install.html#psycopg-vs-psycopg-binary

Although i must say that i personally have never had any problems with it in development and small scale (personal) deployments

#

Consider storing your package versions in a requirements.txt file and pinning the versions

That way you have a reproducible setup :)

fleet olive Dec 24, 2023, 1:12 AM

#

Package Version

asgiref 3.7.2
Django 5.0
pip 23.3.2
setuptools 65.5.0
sqlparse 0.4.4
typing_extensions 4.9.0
(.venv) andrewstribling@Andrews-MBP ch4-bookstore %

#

pinning the versions?

#

so I install psycopg[binary] correct?

#

I seem to still be getting the error when i do psycopg[binary]

analog cypress Dec 24, 2023, 1:15 AM

#

pip install psycopg[binary]==YOUR_VERSION_NUMBER
(Format documentation for a requirements.txt file: https://pip.pypa.io/en/stable/reference/requirements-file-format/)

fleet olive Dec 24, 2023, 1:15 AM

#

https://paste.pythondiscord.com/C7AA

analog cypress Dec 24, 2023, 1:15 AM

#

fleet olive so I install psycopg[binary] correct?

That'll install the newest version, you want a specific one

#

Oh wait, you updated django to 5, alright then, yea
pip install psycopg[binary] will suffice

#

(Make sure you reactivated your env, when you recreated it)

fleet olive Dec 24, 2023, 1:16 AM

#

i have to restart my enviornment?

analog cypress Dec 24, 2023, 1:17 AM

#

venv*
Virtual environment

Just close the terminal and reopen, or run "deactivate" followed by "export /.venv/bin/activate"

fleet olive Dec 24, 2023, 1:17 AM

#

attempting

#

grrrr I am still having an error for some reason

#

one sec let me export

analog cypress Dec 24, 2023, 1:18 AM

#

Can you send the traceback?

fleet olive Dec 24, 2023, 1:18 AM

#

yes one moment

#

https://paste.pythondiscord.com/KG7A

#

Thank you for assisting me by the way

#

psyopg[binary]==YOUR_VERSION_NUMBER what do you mean by that

analog cypress Dec 24, 2023, 1:21 AM

#

fleet olive psyopg[binary]==YOUR_VERSION_NUMBER what do you mean by that

Just the way you'd install a specific version using pip, but nevermind that, you upgraded django (which is probably the right idea anyways :P)

#

Interesting, hmm

#

Which ENGINE did you specify in your settings.py?

#

in your DATABASES section

fleet olive Dec 24, 2023, 1:25 AM

#

checking

#

https://paste.pythondiscord.com/IXNQ

#

postgress

analog cypress Dec 24, 2023, 1:27 AM

#

ehrm

#

DATABASES = DATABASES = {
On line 77

#

That should probably only be DATABASES = {

#

(Although it shouldn't be causing the problem you have)

fleet olive Dec 24, 2023, 1:30 AM

#

fixed

#

how can I tell if my virtual enviornment has it?

#

pip list correct?

analog cypress Dec 24, 2023, 1:32 AM

#

I'd recommend deleting your venv folder and creating a new one, maybe thats the problem

analog cypress Dec 24, 2023, 1:32 AM

#

fleet olive pip list correct?

Yep

fleet olive Dec 24, 2023, 1:32 AM

#

maybe my interpreter is targeting the wrong enviornment?

analog cypress Dec 24, 2023, 1:32 AM

#

That lists all installed packages that the current interpreter has access to (well, not quite, just the ones that pip found, but you're not using other package managers, so yes)

fleet olive Dec 24, 2023, 1:33 AM

#

if I uninstall django and psycopg

#

than deactivate my enviornment

analog cypress Dec 24, 2023, 1:33 AM

#

fleet olive maybe my interpreter is targeting the wrong enviornment?

I'd just go for deleting the .venv folder, and creating a new one with "python3 -m venv .venv"
And then installing your packages

fleet olive Dec 24, 2023, 1:33 AM

#

so just try deleting the venv folder and try again

analog cypress Dec 24, 2023, 1:33 AM

#

Inbetween creating the new venv and installing the packages you should probably close your terminal

#

(or call "deactivate")

fleet olive Dec 24, 2023, 1:34 AM

#

attempting

#

attempting

#

WHY DOES IT PERSIST!?

analog cypress Dec 24, 2023, 1:41 AM

#

Are you on windows?
I've had some wonky behavior with psycopg on windows in the past

fleet olive Dec 24, 2023, 1:41 AM

#

macbook

analog cypress Dec 24, 2023, 1:42 AM

#

Alright then, hmm

fleet olive Dec 24, 2023, 1:43 AM

#

should I github push this

analog cypress Dec 24, 2023, 1:44 AM

#

try and create an empty dummy project with a new, fresh virtual environment

Lets see if its something in your project

fleet olive Dec 24, 2023, 1:47 AM

#

https://github.com/strikeouts27/django_for_professionals_bookstore.git

GitHub

GitHub - strikeouts27/django_for_professionals_bookstore

Contribute to strikeouts27/django_for_professionals_bookstore development by creating an account on GitHub.

analog cypress Dec 24, 2023, 1:49 AM

#

fleet olive https://github.com/strikeouts27/django_for_professionals_bookstore.git

You just uploaded a more or less empty README

Imma go sleep (its nearly 3 o clock am over here), if nobody else gets on this in the meantime i'll try and help out tomorrow (technically today) :)

fleet olive Dec 24, 2023, 1:52 AM

#

you have helped me many times before and I thank you for it JaK

#

(project_env) andrewstribling@Andrews-MBP ch4-bookstore % docker-compose exec web python3 manage.py startapp accounts

fleet olive Dec 24, 2023, 4:06 AM

#

analog cypress You just uploaded a more or less empty README Imma go sleep (its nearly 3 o clo...

I have re pushed the files

versed spoke Dec 24, 2023, 7:32 AM

#

What's your database engine?

#

I have seen few blogs where people have used postgresql_psycopg as engine, not just postgresql, specially with psycopg binary

#

    "default": {
        "ENGINE": "django.db.backends.postgresql", # try postgresql_psycopg
        "NAME": "postgres",
        "USER": "postgres",
        "PASSWORD": "postgres",
        "HOST": "db", # this should be loclahost if you're running on local machine
        "PORT": 5432,
    }
}```

#

Another point to note when using virtual environment with VS Code is, always check that your venv is selected as interpreter, and then kill all terminal and reopen.

You terminal should be something like
(venv) path

#

Though these were the only issues I've faced given the context, since you're running your project in docker, it may have a different reason.

#

I have no experience with docker yet.

analog cypress Dec 24, 2023, 4:28 PM

#

fleet olive I have re pushed the files

I've just noticed, you're running the debian slim docker image, the slim version is not recommended in scenarios where you aren't incredibly storage bound.

Try it out with the normal debian one and lets see if that changes things (i don't even know what debian slim is missing in comparison - probably some binaries like nano)

#

I'd put money on that being the problem

Also, your engine "django.db.backends.postgresql" was totally fine, leave it at that.
The django 4.2 release notes even state that specifically.
https://docs.djangoproject.com/en/5.0/releases/4.2/#what-s-new-in-django-4-2

you don’t need to change the ENGINE as django.db.backends.postgresql supports both libraries.

Also, your HOST setting for the database was also totally correct, as long as your database container is actually called "db"

Django Project

Django

The web framework for perfectionists with deadlines.

analog cypress Dec 24, 2023, 4:32 PM

#

versed spoke ```DATABASES = DATABASES = { "default": { "ENGINE": "django.db.backe...

Just as a quick explanation why "db" is set as the hostname:
If you have a docker network, your containers can refer to each other by name.
Docker will inject the docker network ip addresses of the containers with their container name in any other containers hosts file

You wouldn't want to use localhost, as there could be other containers running on the same system, using the same port, you specifically want the container named "db" (That might also not be exposing its port to the host's network)

versed spoke Dec 24, 2023, 4:46 PM

#

I see, so that's how it is. Thanks for the explanation, I'll start learning Docker soon.

fleet olive Dec 28, 2023, 6:40 AM

#

Is there a way to understand how each part of the docker file works and know what is acceptable and is not?

#Psyopg2[binary] not working