PGroonga in the Postgresql docker image

[tassoman]

Docker's Postgres image is loaded from Alpine Linux, but documentation points on how to install into ubuntu. Also PGroonga documentation points at Ubuntu.
Any idea on how do I get the extension on a postgres:15-alpine image?

[AmaseCocoa]

Replace postgresql image to groonga/pgroonga:latest-alpine-15-slim?

This postgres image is include pgroonga

[tassoman]

I was able to start up the fresh containers without any error inside logs. But frontend search is not working.

[eternal-flame-AD]

You need to enable the extension and build the inverted index first.

https://github.com/misskey-dev/misskey-hub-next/blob/b0a22e8bb7b7b912d0335996d5b0f1d1fafa5c55/content/ja/docs/3.for-admin/features/search.md?plain=1#L67-L99

I doesn't seem to have english translation but TLDR is just run these commands.

Also: you might need to change your user role settings to allow searching

[tassoman]

I've already added the extension in the database, then added the indexed column.
But, I forgot default role was unable to search notes, only profiles. Thanks!

[AmaseCocoa]

You're right! Thanks, maybe documentation could be updated with this hint? 💭

That's good idea 👀 , I will do it (misskey-dev/misskey-hub-next#357)

[tassoman]

Maybe we can also change this line, pointing to your updated documentation? 👀
https://github.com/misskey-dev/misskey/blob/develop/.config/docker_example.yml#L130