could not link file in wal restore lines

2022-07-15 Thread Zsolt Ero
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/000101560098" to "pg_wal/00010157006E": File exists In total, I get 18 lines of "could not link file" and 932 lines of "restored log file" lines.

Re: could not link file in wal restore lines

2022-07-21 Thread Zsolt Ero
est/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 wrote: > H

refresh materialized view concurrently alternatives

2019-07-03 Thread Zsolt Ero
Hi, I'm using refresh materialized view concurrently at the moment. I have a few problems with it: 1. It requires adding a unique index, even if it's never actually used. This can just create wasted space and bad cache utilization. 2. It locks the table so that two refresh commands cannot be run