No PostgreSQL driver in docker image for 1.0.16

[hakan-77]

Bug Description

No PostgreSQL driver in docker image for 1.0.16 (No module named 'psycopg2')

Reproduction

Install using docker image, connect to postgresql

Expected behavior

psycopg2 is installed

Who can help?

No response

Operating System

Ubuntu 22.04

Langflow Version

1.0.16

Python Version

None

Screenshot

No response

Flow File

No response

[hakan-77]

Update: I see that pycopg is installed instead, but forcing to use pycopg instead of pycopg2 doesn't work either since the binary elements are missing.

Can the dependencies list use pycopg[binary] insread of just pycopg? I can confirm this works.

[dosubot]

Yes, the dependencies list can use pycopg[binary] instead of just pycopg in the Docker image for Langflow version 1.0.16 to ensure PostgreSQL driver compatibility. You can modify the pyproject.toml file to include psycopg[binary]:

[tool.poetry.dependencies]
psycopg = { version = "3.1.9", extras = ["binary"] }

This change will ensure that the binary version of the psycopg package is used, which can help with compatibility and performance ^[1][2].

To continue talking to Dosu, mention @dosu.

[italojohnny]

This issue is related to issue #3524