moriksan
moriksan
PostsComments
IImmich
Created by moriksan on 2/11/2025 in #help-desk-support
postgres related issue?
Hello, I'm running immich v1.125.7 docker on ubuntu 22.04 VM. Database is a postgres16 with 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 directly on pgs also work as expected. In converting the pgs db to clustered mode and performing 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 which appears to be linked to problem. The only reason for why pgvector.rs extension was installed on my pgs was to support immich. In further searches, it appears that pgvector.rs is to be replaced w/ a newer library 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 to get over the pgvector.rs imposed limitation?
7 replies