David Steele

Results 411 comments of David Steele
trafficstars

This is actually a lot more work than it looks like. By the time we know the checkpoint_timeout the protocol has already been negotiated and all timeouts are set. So...

It's definitely annoying that auth is different in every single one of their products. We would be happy to use an SDK if there was one for C. In this...

Looks to me like you have a bad timestamp: ``` WARN: file 'base/16399/39612_vm' has same timestamp as prior but different size, enabling delta checksum ``` This is forcing pgBackRest into...

> Its not NFS, it is a local ext4 filesystem. That's a bit worrisome then. The file size changed from the full backup but the timestamp did not. Could be...

You'd need to look in `/opt/postgres/pgbackup/pgbackrest/backup/dayzerprd/20220514-010003F/backup.manifest` for `base/16399/39612_vm` and see what the size/timestamp was when that full backup was made.

If possible, it would be good to get a copy of `20220514-010003F/backup.manifest` and `20220514-010003F_20220516-010003D/backup.manifest`. Then we can compare and see what is going on. It looks like stat might be...

Looks like the file did not change: ``` 20220514-010003F: pg_data/base/16399/39612_vm={"checksum":"958d083742eb0351a064906a76f5bb9bfebe39eb","repo-size":48050,"size":8978432,"timestamp":1648986341} 20220514-010003F_20220516-010003D: pg_data/base/16399/39612_vm={"checksum":"958d083742eb0351a064906a76f5bb9bfebe39eb","repo-size":48050,"size":8978432,"timestamp":1648986341} ``` So it appears we are getting a different value from `stat`. What kind of storage is this?...

Agreed, this is a good idea. We've been considering it for a while but wanted to wait for the C migration to be complete before implementing. Thank you for the...

We can add an `EEXISTS` check here but I'm a bit worried that you are doing two restores to the same stanza on the same host. If you start recovery...

Note that this feature has been implemented (but not yet merged) in pgbackrest/pgbackrest#1137. We fully expect it to be included in the next release, currently scheduled for July 25.