Postgres 18 support?

[VikShepo]

Hello!
I have netbox on my Synology installed as a docker. The problem is when I pg_dumpall Postgres database from netbox and psql -d the backup it throws multiple errors.
Is netbox compatible with postgres 18? I have seen #1523 have already been merged into main.
And if yes how to upgrade the database?

Thank you!

[ColtonDx]

I don't know if this will be relevant for you, but if you're starting your new Postgres 18 container when you start the Netbox container, it will initialize the DB and you will get errors like these:
ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ERROR: column "_location_id" referenced in foreign key constraint does not exist ERROR: column "_region_id" referenced in foreign key constraint does not exist ERROR: column "_site_group_id" referenced in foreign key constraint does not exist ERROR: column "_site_id" referenced in foreign key constraint does not exist ERROR: constraint "wireless_wirelesslan_group_id_d9e3d67f_fk_wireless_" for relation "wireless_wirelesslan" already exists ERROR: constraint "wireless_wirelesslan_parent_id_37ca8b87_fk_wireless_" for relation "wireless_wirelesslangroup" already exists ERROR: column "scope_type_id" referenced in foreign key constraint does not exist ERROR: constraint "wireless_wirelesslan_tenant_id_5dfee941_fk_tenancy_tenant_id" for relation "wireless_wirelesslan" already exists ERROR: constraint "wireless_wirelesslan_vlan_id_d7fa6ccc_fk_ipam_vlan_id" for relation "wireless_wirelesslan" already exists ERROR: constraint "wireless_wirelesslin__interface_a_device__6c8e042e_fk_dcim_devi" for relation "wireless_wirelesslink" already exists ERROR: constraint "wireless_wirelesslin__interface_b_device__43d5101a_fk_dcim_devi" for relation "wireless_wirelesslink" already exists ERROR: constraint "wireless_wirelesslin_interface_a_id_bc9e37fd_fk_dcim_inte" for relation "wireless_wirelesslink" already exists ERROR: constraint "wireless_wirelesslin_interface_b_id_a82fb2ee_fk_dcim_inte" for relation "wireless_wirelesslink" already exists ERROR: constraint "wireless_wirelesslink_tenant_id_4c0638ee_fk_tenancy_tenant_id" for relation "wireless_wirelesslink" already exists

The fix for me was to create a new Postgres:18 container that wasn't associated to Netbox at all, then use psql to restore the backup. Then I was able to move the volume from this container to the existing compose that runs Netbox and then set the Postgres version to 18. Idk the Synology-isms for this but just running docker compose on Debian this worked for me.

[VikShepo]

Hey ColtonDx! Exactly this problem I got everytime! I will try it out :)

[VikShepo]

Ok I tried it out and it worked!

I have created a seperate postgres:18 container:
postgres_18: image: postgres:latest container_name: postgres_18 command: postgres ports: - "13032:5432" volumes: - /volume1/docker/netbox/postgres-18-db:/var/lib/postgresql/18/data - /volume1/docker/netbox/backup:/backup environment: POSTGRES_DB: netbox POSTGRES_USER: netbox-user POSTGRES_PASSWORD: netbox-pass PGDATA: /var/lib/postgresql/18/data LANG: en_US.utf8 PG_MAJOR: "18" GOSU_VERSION: "1.17" restart: on-failure:5

I bound volumes oinside netbox directory in a seperate folder which is empty:
/volume1/docker/netbox/postgres-18-db:/var/lib/postgresql/18/data

Afterwards I stopped netbox with postgres 17 and started the postgres 18 container to generate the database for postgres 18.
Then I stopped postgres 18 container and started netbox together with postgres 17.

Then I have sshed inside postgres 17 in portainer and gave this command:
pg_dumpall -U $POSTGRES_USER > /backup/postgres17_backup.dump

It saved.

Then I stopped the netbox container and started postgres 18 and sshed inside.
Then I gave the command:
psql -d $POSTGRES_DB -U $POSTGRES_USER < /backup/postgres17_backup.dump

After that it indexed and created tables without mistakes.
Then I edited the volumes main compose with the postgres18 container and it worked!

Thank You ColtonDx!

Thread closed