Darknicks Comments - Answer Overflow

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

28 replies

IImmich

•Created by Darknicks on 5/23/2025 in #help-desk-support

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

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

28 replies

IImmich

•Created by Darknicks on 5/23/2025 in #help-desk-support

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

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

28 replies

IImmich

•Created by Darknicks on 5/23/2025 in #help-desk-support

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

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.

28 replies

Gaming

Programming