Re: could not link file in wal restore lines

Can someone with knowledge about PG tell me if this is a bug and if there
is any need to worry about data corruption?

Here is the issue which I've opened for pgbackrest, the developer confirmed
that pgbackrest doesn't change those files at all.

https://github.com/pgbackrest/pgbackrest/issues/1815

It's PG 12 on Ubuntu 18.04. I always start with a clean data folder and can
replicate this 100% any time I do a restore. Single master, no cluster or
replication, backup/restore is from the same partition.

Thanks,
Zsolt

On 15. Jul 2022 at 22:11:09, Zsolt Ero <zsolt(dot)ero(at)gmail(dot)com> wrote:

> Hi,
>
> I'm testing pgbackrest restore.
>
> It works well, but in the pg logs I get the following lines:
>
> could not link file "pg_wal/000000010000015600000098" to
> "pg_wal/00000001000001570000006E": File exists
>
> In total, I get 18 lines of "could not link file" and 932 lines of
> "restored log file" lines.
>
> At the end it finishes with:
>
> redo done at 15A/A001710
> last completed transaction was at log time 2022-07-15 19:41:05.175573+00
> restored log file "000000030000015A0000000A" from archive
> selected new timeline ID: 4
> archive recovery complete
> restored log file "00000003.history" from archive
> database system is ready to accept connections
>
> Before going in production, I wanted to ask, if this is correct like this?
> I mean are those "could not link file" lines anything to worry about?
>
> Thanks and regards,
> Zsolt
>
>
>
>