Re: could not link file in wal restore lines

Поиск
Список
Период
Сортировка
От Zsolt Ero
Тема Re: could not link file in wal restore lines
Дата
Msg-id CAKw-smBhcQ0BGcNxzDcb_-_dMXMdbD3Lm_3tfPvxTvYOf4TcCA@mail.gmail.com
обсуждение исходный текст
Ответ на could not link file in wal restore lines  (Zsolt Ero <zsolt.ero@gmail.com>)
Список pgsql-general
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.


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@gmail.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



В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: FK Constraint sort order with pg_dump
Следующее
От: Taka Taka
Дата:
Сообщение: Is psqlodbc_13_02 compatible to M365?