lemmy_admin

skullgiver, 7 months ago (edited 7 months ago) in [SOLVED] Duplicate entries in Lemmy database

deleted_by_author

Illecors, 7 months ago

If the whole table is truncated - then potentially yes, if said activity gets retransmitted. But retransmission is only done to active nodes, and they get marked inactive if unresponsive for 3 days.

So realistically - no.

taaz, 6 months ago (edited 6 months ago) in Postgresql connectivity issue

Considering you are getting No such file or directory error then

1. Is the path correct?
2. Can lemmy access the file? For example if lemmy is running in docker the path/socket does not exist in the container unless specifically instructed…
3. Does lemmy process have the required permissions to actually read/access the file?

idefix, 6 months ago

The path is correct, my investigations directed me towards a docker access issue as suggested by your #2. Looking into it now, thanks!

taaz, 6 months ago (edited 6 months ago)

If lemmy is actually running in docker then you should rather use network instead of socket file - while it should work I would be afraid of docker shenanigans when it comes to mounting a socket file as volume into the container (it should work, but …).

You should be able to access postgres over network on the host thru extra_hosts settings:

<span style="color:#323232;">extra_hosts:
</span><span style="color:#323232;">    - "host.docker.internal:host-gateway"
</span>

stackoverflow.com/a/43541732

postgres://host.docker.internal:5432

idefix, 6 months ago

My investigations so far have led me to the conclusion that the Ansible install creates multiple docker containers, including one for Lemmy and one for Postgresql. I need now to figure out how inter-container communications work but the host itself is not used.