You have to manually update it - we have to every day at least. It’s a psql command.
I think it’s
UPDATE instances SET favicon = 'https://rally.guide/favicon.png'; WHERE host = 'rally.guide';
So if you save that as a script and then run a crontab job every day about the time that it disappears, it’ll auto-update.
I use sudo -Hu postgres psql < update-favicon.sql
Matty /
npub13v…2hy07
2023-05-22 01:20:32
in reply to nevent1q…qwul
Author Public Key
npub13v68j9479je6h958e84h32xs2gjvq3duuk6pd0w4q95evh4s73wqk2hy07Published at
2023-05-22 01:20:32Event JSON
{
"id": "1402983fba877c0586df1ad7b920b6e5dce03a2933207c1492dac6c027623da8",
"pubkey": "8b347916be2cb3ab9687c9eb78a8d05224c045bce5b416bdd50169965eb0f45c",
"created_at": 1684718432,
"kind": 1,
"tags": [
[
"p",
"ac691c3499196b3103f8e6b571741b4a7b2d73c2c6f681e71cd975febae76c12",
"wss://relay.mostr.pub"
],
[
"p",
"79c4b3e2b1e7d8d74fa652cdc1dee37f9cd08fefdc13a79f8d1146c0b69fd1fb",
"wss://relay.mostr.pub"
],
[
"e",
"48d4f95793068b04c9b3ba1e3e487eb9fb0a9fcee1b4214b1fc306c709fa9ccf",
"wss://relay.mostr.pub",
"reply"
],
[
"mostr",
"https://nicecrew.digital/objects/fe60e88a-7c8e-489a-8e49-51279d0d4bc4"
]
],
"content": "You have to manually update it - we have to every day at least. It’s a psql command.\n\nI think it’s \n\nUPDATE instances SET favicon = 'https://rally.guide/favicon.png' WHERE host = 'rally.guide';\n\nSo if you save that as a script and then run a crontab job every day about the time that it disappears, it’ll auto-update.\n\nI use sudo -Hu postgres psql \u003c update-favicon.sql",
"sig": "0dec76018853c498b4bdafbc05615cc0647852587abf6241385f8770020f6f31196bc3922a615def08c07da3f4b1fa432a69ec59fd3c5b7726b7288d63e52b5e"
}