Upgrade to psycopg3 #6220

Closed
opened 2025-12-29 19:38:10 +01:00 by adam · 1 comment
Owner

Originally created by @ndTEC on GitHub (Mar 17, 2022).

NetBox version

v3.1.9

Feature type

Change to existing functionality

Proposed functionality

psycopg3 has the ability to connect to a postgresql server using a uri. docs
The uri can look like this.

Use case

This is very useful when you have a cluster of Postgresql with pg_auto_failover
You can pass a link like this:
postgresql://host1:123,host2:456/somedb?target_session_attrs=any&application_name=myapp

Database changes

No response

External dependencies

psycopg3

Originally created by @ndTEC on GitHub (Mar 17, 2022). ### NetBox version v3.1.9 ### Feature type Change to existing functionality ### Proposed functionality psycopg3 has the ability to connect to a postgresql server using a uri. [docs](https://www.psycopg.org/psycopg3/docs/api/conninfo.html) The uri can look like [this.](https://www.postgresql.org/docs/current/libpq-connect.html#:~:text=34.1.1.2.%C2%A0-,Connection%20URIs,-The%20general%20form) ### Use case This is very useful when you have a cluster of Postgresql with pg_auto_failover You can pass a link like this: postgresql://host1:123,host2:456/somedb?target_session_attrs=any&application_name=myapp ### Database changes _No response_ ### External dependencies psycopg3
adam added the type: feature label 2025-12-29 19:38:10 +01:00
adam closed this issue 2025-12-29 19:38:11 +01:00
Author
Owner

@jeremystretch commented on GitHub (Mar 18, 2022):

From what I understand, Django does not yet support psycopg3, though there is an active feature request. I'm sure we'll make it available if and when support is introduced in Django officially.

@jeremystretch commented on GitHub (Mar 18, 2022): From what I understand, Django does not yet support psycopg3, though there is an [active feature request](https://code.djangoproject.com/ticket/33308). I'm sure we'll make it available if and when support is introduced in Django officially.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/netbox#6220