On 4/6/22 11:04 AM, W.P. wrote:
> W dniu 06.04.2022 o 18:54, Ron pisze:
> I know about restoring backup. I just don't have one (at least with
> reasonnable age), as it is experimental installation. (Didn't ever been
> thinking about locating production DB on USB drive :) ).
>
If it is experimental you could try pg_resetwal:
https://www.postgresql.org/docs/11/app-pgresetwal.html
Read all the way through for the ifs/ands/buts.
> If it is not possible to get rid ("somehow") of this "replication
> error", I will do a "logic restore" -> I have similar database on my
> laptop, so I'll get a pg_dumpall from this one, then recreate fresh DB
> on OPi and restore from SQL.
>
>
> It looks that DATA in PG DB is protected by various mechanisms very
> well, but "dictionary data" (in this case replication data) is not (as
> much). And in my case ext4 recovery mechanisms failed.
>
> This makes me logical replication more appealing.
>
>
> Laurent
>
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com