Hide Faces Feature
I accidentally hid some faces with the new Show & Hide faces feature and i want to get them back.
MDo you have more than 500 faces ?
Lprobably yea
MUnfortunately for now, there’s not straightforward solution and you have to update manually your database
Lis there a fix in the foreseeable future
MOf course !
MIt’s the number 4.a here
MGitHub
(Parent discussion for FR enhancements) Summary: 1. Ability to show/hide faces (similar to google photos) (#3262) 2. Option to select an alternative person thumbnail (similar to google photos) (#30...
Lgood to hear that thank you very much!
MYou’re welcome 
LWhen does the bug get fixed?
M
LCoult you show me were i find the instruction to manually edit the database
MDo you have some experience with postgres and psql ?
Lyea a little
Li think i already know enough. i used dbeaver software to edit databases.
MNice
MShould be easy with dbeaver
MConnect to your immich database, go to the "person" table
MAll the people you hid have the isHidden row set to
trueIf you have set a name to the person you accidentally hid, it should be easy to find
Lthanks. do you know what the credentials for the database are
MIf you didn't set a name, my recommendation would be to set
false to all isHidden entriesMNo, but you can find it in your .env file 
MIf you didn't change it, the username and password should be
postgresLstill cant connect, also treid the hostname from the .env file. any tipps
MYes don't use localhost
Muse directly your ip address
L
Ldo you have any idea why i still doesnt work
MAre you sure you used the correct password ?
Lyes i am
LThe issue still isnt resolved and i cant connect to the database could you take a look at that one more time?
MCan you try to query your table in your Postgres docker ?
MNormally the DB shouldnt be exposed to the outside by default
Probably the port isnt open, but you could temporarily change that
Probably the port isnt open, but you could temporarily change that
LCan you explain how?
Aexpose port 5432 on the postgres container in the docker-compose
Llike this?
Lenvironment:
POSTGRES_PASSWORD: ${DB_PASSWORD}
POSTGRES_USER: ${DB_USERNAME}
POSTGRES_DB: ${DB_DATABASE_NAME}
PG_DATA: /var/lib/postgresql/data
expose:
POSTGRES_PASSWORD: ${DB_PASSWORD}
POSTGRES_USER: ${DB_USERNAME}
POSTGRES_DB: ${DB_DATABASE_NAME}
PG_DATA: /var/lib/postgresql/data
expose:
- "5432"
Lsorry the markdown editing kicks in
L
Mjust use a raw block :')
Mshould work, i would just use
Mshould be the same though
Lthank you very much! mine didnt work but with your option it did