I accidentally hid some faces with the new Show & Hide faces feature and i want to get them back.
#Hide Faces Feature
cyan pollen
shut gazelle
Do you have more than 500 faces ?
cyan pollen
probably yea
shut gazelle
Unfortunately for now, there’s not straightforward solution and you have to update manually your database
cyan pollen
is there a fix in the foreseeable future
cyan pollen
good to hear that thank you very much!
shut gazelle
You’re welcome 😁
cyan pollen
When does the bug get fixed?
shut gazelle
🤷🏻♂️
cyan pollen
Unfortunately for now, there’s not straightforward solution and you have to upda...
Coult you show me were i find the instruction to manually edit the database
shut gazelle
Do you have some experience with postgres and psql ?
cyan pollen
yea a little
cyan pollen
Do you have some experience with postgres and psql ?
i think i already know enough. i used dbeaver software to edit databases.
shut gazelle
Nice
Should be easy with dbeaver
Connect to your immich database, go to the "person" table
All the people you hid have the isHidden row set to true
If you have set a name to the person you accidentally hid, it should be easy to find
cyan pollen
thanks. do you know what the credentials for the database are
shut gazelle
If you didn't set a name, my recommendation would be to set false to all isHidden entries
No, but you can find it in your .env file 😉
If you didn't change it, the username and password should be postgres
cyan pollen
still cant connect, also treid the hostname from the .env file. any tipps
shut gazelle
Are you sure you used the correct password ?
cyan pollen
yes i am
cyan pollen
The issue still isnt resolved and i cant connect to the database could you take a look at that one more time?
shut gazelle
Can you try to query your table in your Postgres docker ?
wooden sluice
Normally the DB shouldnt be exposed to the outside by default
Probably the port isnt open, but you could temporarily change that
cyan pollen
Can you explain how?
sand coral
Can you explain how?
expose port 5432 on the postgres container in the docker-compose
cyan pollen
like this?
environment:
POSTGRES_PASSWORD: ${DB_PASSWORD}
POSTGRES_USER: ${DB_USERNAME}
POSTGRES_DB: ${DB_DATABASE_NAME}
PG_DATA: /var/lib/postgresql/data
expose:
- "5432"
sorry the markdown editing kicks in
wooden sluice
sorry the markdown editing kicks in
just use a raw block :')