Re: could not link file in wal restore lines

[Zsolt Ero <zsolt.ero@xxxxxxxxx>]

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.ero@xxxxxxxxx> 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