Immich•12mo ago•

6 replies

postgres related issue?

Hello,
I'm running immich

v1.125.7

v1.125.7

docker on ubuntu 22.04 VM. Database is a

postgres16

postgres16

with

pgvector.rs

pgvector.rs

extension enabled and installed. Immich web and client apps work brilliantly. The pgs db was running in non-clustered mode. Regular datadumps via

pg_dumpall

pg_dumpall

directly on pgs also work as expected.
In converting the pgs db to clustered mode and performing

pg_basebackup

pg_basebackup

is where the following issue arose.:

pg_basebackup: created temporary replication slot "pg_basebackup_1061367"
WARNING:  aborting backup due to backend exiting before pg_backup_stop was called
pg_basebackup: error: backup failed: ERROR:  file name too long for tar format: "pg_vectors/indexes/0000000000000000000000000000000065108e3592719d3e0000556c000059e4/segments/6fdc79e5-709c-4981-ae0b-bb5325801815"
pg_basebackup: removing contents of data directory "/var/lib/postgresql/16/main"

pg_basebackup: created temporary replication slot "pg_basebackup_1061367"
WARNING:  aborting backup due to backend exiting before pg_backup_stop was called
pg_basebackup: error: backup failed: ERROR:  file name too long for tar format: "pg_vectors/indexes/0000000000000000000000000000000065108e3592719d3e0000556c000059e4/segments/6fdc79e5-709c-4981-ae0b-bb5325801815"
pg_basebackup: removing contents of data directory "/var/lib/postgresql/16/main"

In digging further, I came across this issue with

pgvector.rs

pgvector.rs

which appears to be linked to problem. The only reason for why

pgvector.rs

pgvector.rs

extension was installed on my pgs was to support immich. In further searches, it appears that

pgvector.rs

pgvector.rs

is to be replaced w/ a newer library

vectorchord?

vectorchord?

. However, until such time, would someone be so kind as to point me in the right direction as to how might I fix this probelm so as to allow

pg_basebackup

pg_basebackup