Immich•2w ago

How to downgrade from pgvecto-rs:pg15-v0.2.0 to pgvecto-rs:pg15-v0.2.0 ?

I have a dump.sql.gz file database from an Immich installation that used pgvecto-rs:pg15-v0.2.0 by mistake. I got it following the instructions here: https://immich.app/docs/administration/backup-and-restore/ I tried to restore it back to pgvecto-rs:pg14-v0.2.0 but I got a few errors. How can I successfully downgrade from pgvecto-rs:pg15-v0.2.0 to pgvecto-rs:pg14-v0.2.0? I don't want to keep using pgvecto-rs:pg15-v0.2.0. Thanks in advance!

15 Replies

Immich•2w ago

:wave: Hey @Darknicks, Thanks for reaching out to us. Please carefully read this message and follow the recommended actions. This will help us be more effective in our support effort and leave more time for building Immich :immich:. References - Container Logs: docker compose logs docs - Container Status: docker ps -a docs - Reverse Proxy: https://immich.app/docs/administration/reverse-proxy - Code Formatting https://support.discord.com/hc/en-us/articles/210298617-Markdown-Text-101-Chat-Formatting-Bold-Italic-Underline#h_01GY0DAKGXDEHE263BCAYEGFJA Checklist I have... 1. :blue_square: verified I'm on the latest release(note that mobile app releases may take some time). 2. :blue_square: read applicable release notes. 3. :blue_square: reviewed the FAQs for known issues. 4. :blue_square: reviewed Github for known issues. 5. :blue_square: tried accessing Immich via local ip (without a custom reverse proxy). 6. :blue_square: uploaded the relevant information (see below). 7. :blue_square: tried an incognito window, disabled extensions, cleared mobile app cache, logged out and back in, different browsers, etc. as applicable (an item can be marked as "complete" by reacting with the appropriate number) Information In order to be able to effectively help you, we need you to provide clear information to show what the problem is. The exact details needed vary per case, but here is a list of things to consider: - Your docker-compose.yml and .env files. - Logs from all the containers and their status (see above). - All the troubleshooting steps you've tried so far. - Any recent changes you've made to Immich or your system. - Details about your system (both software/OS and hardware). - Details about your storage (filesystems, type of disks, output of commands like fdisk -l and df -h). - The version of the Immich server, mobile app, and other relevant pieces. - Any other information that you think might be relevant. Please paste files and logs with proper code formatting, and especially avoid blurry screenshots. Without the right information we can't work out what the problem is. Help us help you ;) If this ticket can be closed you can use the /close command, and re-open it later if needed.

bo0tzz•2w ago

Why? pg15 is fine

DarknicksOP•2w ago

Because pg14 is the official one And now is getting changed to postgres:14-vectorchord0.3.0-pgvectors0.2.0 I don't want to have a different configuration/setup than the official one.

SET
SET
SET
DROP DATABASE
NOTICE:  role "immich" does not exist, skipping
DROP ROLE
ERROR:  current user cannot be dropped
CREATE ROLE
ALTER ROLE
ERROR:  role "postgres" already exists
ALTER ROLE
SET
SET
SET
SET
SET
     set_config
--------------------
 public, pg_catalog
(1 row)

SET
SET
SET
SET
UPDATE 1
DROP DATABASE
ERROR:  option "locale_provider" not recognized
LINE 1: ...late1 WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PRO...
                                                             ^
ERROR:  database "template1" does not exist
\connect: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "template1" does not exist

SET
SET
SET
DROP DATABASE
NOTICE:  role "immich" does not exist, skipping
DROP ROLE
ERROR:  current user cannot be dropped
CREATE ROLE
ALTER ROLE
ERROR:  role "postgres" already exists
ALTER ROLE
SET
SET
SET
SET
SET
     set_config
--------------------
 public, pg_catalog
(1 row)

SET
SET
SET
SET
UPDATE 1
DROP DATABASE
ERROR:  option "locale_provider" not recognized
LINE 1: ...late1 WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PRO...
                                                             ^
ERROR:  database "template1" does not exist
\connect: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "template1" does not exist

That's the error I'm getting when I try to restore

Daniel•2w ago

Going back to pg14 is more headache than just staying on pg15 There's literally no reason to downgrade We also have migration images for pg15 (and 16 fwiw)

DarknicksOP•2w ago

I'm probably going to forget I have pg15 If in the future I have an issue just because I have pg15, I'll probably end up being frustrated for wasting so much time. It took a long time to migrate from the TrueNAS implementation of Immich to the official Docker Compose implementation That's why I would like to upgrade now to avoid any future headaches What does that mean? I apologize.

Daniel•2w ago

If in the future I have an issue just because I have pg15

That is incredibly unlikely

bo0tzz•2w ago

The new image is also available for pg15

Daniel•2w ago

You can just use postgres:15-vectorchord0.3.0-pgvectors0.2.0 (replace the 14 with 15)

DarknicksOP•2w ago

OK I hope I don't have issues in the future

Daniel•2w ago

I cannot guarantee you that But I can (almost) guarantee you it won't be because of pg15 :P

DarknicksOP•2w ago

You would be surprised how long it took for me to migrate from TrueNAS apps to the Official Docker Compose implemenation

Daniel•2w ago

And we'll upgrade to pg18 at some point anyways, so by then you can upgrade as well and everyone will be on the same version :)

DarknicksOP•2w ago

I don't know why TrueNAS used 15 when Immich recommends 14 I see. Thank you very much.

sogan•2w ago

There’s no technical reason why immich needs 14, we just never changed the default In fact I’d personally recommend pg17 since it naturally has improvements over older versions But you can just use pg15 without worry as well

DarknicksOP•2w ago

OK Thanks a lot

Gaming

Programming

How to downgrade from pgvecto-rs:pg15-v0.2.0 to pgvecto-rs:pg15-v0.2.0 ?

Did you find this page helpful?