Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ✅ Successfully connected as user: immich
- WARNING: database "postgres" has a collation version mismatch
- DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
- HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
- ✅ User immich has superuser privileges
- Terminating connections to database: immich
- pg_terminate_backend
- ----------------------
- (0 rows)
- Dropping database: immich
- WARNING: database "postgres" has a collation version mismatch
- DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
- HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
- DROP DATABASE
- Creating database: immich using template0 to avoid collation issues
- WARNING: database "postgres" has a collation version mismatch
- DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
- HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
- CREATE DATABASE
- Importing backup data...
- SET
- SET
- SET
- SET
- SET
- set_config
- ------------
- (1 row)
- SET
- SET
- SET
- SET
- CREATE SCHEMA
- ALTER SCHEMA
- CREATE EXTENSION
- COMMENT
- CREATE EXTENSION
- COMMENT
- CREATE EXTENSION
- COMMENT
- CREATE EXTENSION
- COMMENT
- ERROR: extension "vectors" is not available
- DETAIL: Could not open extension control file "/usr/share/postgresql/15/extension/vectors.control": No such file or directory.
- HINT: The extension must first be installed on the system where PostgreSQL is running.
- CREATE EXTENSION
- COMMENT
- ERROR: extension "vectors" does not exist
- CREATE TYPE
- ALTER TYPE
- CREATE TYPE
- ALTER TYPE
- CREATE TYPE
- ALTER TYPE
- CREATE FUNCTION
- ALTER FUNCTION
- CREATE FUNCTION
- ALTER FUNCTION
- CREATE FUNCTION
- ALTER FUNCTION
- CREATE FUNCTION
- ALTER FUNCTION
- CREATE FUNCTION
- ALTER FUNCTION
- CREATE FUNCTION
- ALTER FUNCTION
- CREATE FUNCTION
- ALTER FUNCTION
- CREATE FUNCTION
- ALTER FUNCTION
- CREATE FUNCTION
- ALTER FUNCTION
- CREATE FUNCTION
- ALTER FUNCTION
- CREATE FUNCTION
- ALTER FUNCTION
- CREATE FUNCTION
- ALTER FUNCTION
- CREATE FUNCTION
- ALTER FUNCTION
- CREATE FUNCTION
- ALTER FUNCTION
- CREATE FUNCTION
- ALTER FUNCTION
- CREATE FUNCTION
- ALTER FUNCTION
- CREATE FUNCTION
- ALTER FUNCTION
- CREATE FUNCTION
- ALTER FUNCTION
- CREATE FUNCTION
- ALTER FUNCTION
- SET
- SET
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- COMMENT
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ERROR: type "vectors.vector" does not exist
- LINE 3: embedding vectors.vector(512) NOT NULL
- ^
- ERROR: relation "public.face_search" does not exist
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- ERROR: type "vectors.vector" does not exist
- LINE 3: embedding vectors.vector(512) NOT NULL
- ^
- ERROR: relation "public.smart_search" does not exist
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- COPY 0
- COPY 25
- E0924 11:30:04.457288 2040713 v2.go:104] "Unhandled Error" err="write tcp 127.0.0.1:43916->127.0.0.1:6443: write: connection reset by peer"
- E0924 11:30:04.457563 2040713 websocket.go:500] Websocket Ping failed: write tcp 127.0.0.1:43916->127.0.0.1:6443: write: connection reset by peer
- command terminated with exit code 137
- ❌ Failed to import PostgreSQL backup as user: immich
- Checking if backup file is valid PostgreSQL...
- Backup file may not be valid PostgreSQL format
- ❌ Failed to restore /home/spiderunderurbed/db-backups/immich-db/immich_20250923_010405.sql.gz
- =========================================
- All restores completed!
Advertisement
Add Comment
Please, Sign In to add comment