ImmichI
Immich•12mo ago
Bubba

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: Unable to search location in web.

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)


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.
Was this page helpful?