Search Postgresql Archives

Re: could not link file in wal restore lines

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux