Bubba Posts - Answer Overflow

Bubba

•Created by Bubba on 1/4/2025 in #help-desk-support

Unable to search location after database restore

@bo0tzz recently helped me restore my database to a new CNPG instance but I cannot do a location search. I believe that I'm hitting the problem discussed in this thread: https://discord.com/channels/979116623879368755/1316043914863448147/1316043914863448147. When I list the table I see the same output as the OP.

You are now connected to database "immich" as user "postgres".
immich=# select * from geodata_places;
 id | name | longitude | latitude | countryCode | admin1Code | admin2Code | modificationDate | admin1Name | admin2Name | alternateNames 
----+------+-----------+----------+-------------+------------+------------+------------------+------------+------------+----------------
(0 rows)

You are now connected to database "immich" as user "postgres".
immich=# select * from geodata_places;
 id | name | longitude | latitude | countryCode | admin1Code | admin2Code | modificationDate | admin1Name | admin2Name | alternateNames 
----+------+-----------+----------+-------------+------------+------------+------------------+------------+------------+----------------
(0 rows)

Can someone help me with the command to delete the command to "delete the row from the table" as referenced in the thread? I'm worried about doing something wrong in the database.

18 replies

IImmich

•Created by Bubba on 12/31/2024 in #help-desk-support

[SOLVED] pg_restore immich backup into new CNPG instance

1. gunzip immich-db-backup-1735542000019.sql.gz 2. sed "s/SELECT pg_catalog.set_config('search_path', '', false);/SELECT pg_catalog.set_config('search_path', 'public, pg_catalog', true);/g" immich-db-backup-1735542000019.sql > immich-db-backup.sql 3. kubectl -n databases cp ./immich-db-backup.sql postgres-16-1:/var/lib/postgresql/data/ 4. kubectl -n databases exec -it postgres-16-1 -- bash 5. pg_restore -S postgres -U immich -Cev -f /var/lib/postgresql/data/immich-db-backup.sql The last command just hangs with no output. I've tried with a variety of pg_restore options. Any suggestions?

45 replies

IImmich

•Created by Bubba on 12/6/2024 in #help-desk-support

Can I disable CPUExecutionProvider in the Machine Learning container?

I am using CUDAExecutionProvider and I don't want to fallback to CPUExecutionProvider if there is an error. Can I disable CPUExecutionProvider?

12/06/24 16:23:32] INFO     Setting execution providers to                     
                             ['CUDAExecutionProvider', 'CPUExecutionProvider'], 
                             in descending order of preference

12/06/24 16:23:32] INFO     Setting execution providers to                     
                             ['CUDAExecutionProvider', 'CPUExecutionProvider'], 
                             in descending order of preference

4 replies

Gaming

Programming