Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] Does Postgres ever write to tables without file systemtimestamps getting updated? - Mailing list pgsql-admin

From scott ribe
Subject Re: [ADMIN] Does Postgres ever write to tables without file systemtimestamps getting updated?
Date
Msg-id 56559FCA-392D-4F38-8A15-C220892C46C3@elevated-dev.com
Whole thread Raw
In response to Re: [ADMIN] Does Postgres ever write to tables without file systemtimestamps getting updated?  (David Steele <david@pgmasters.net>)
List pgsql-admin
Tree view 
To be clear, for potential future readers, just using checksum is not enough to back up a live database. You still have
touse pg_start_backup and pay attention to its documentation re WAL files. 

> On Jun 6, 2017, at 8:54 AM, David Steele <david@pgmasters.net> wrote:
>
> This is why it is not safe to do incremental backups of PostgreSQL with
> rsync without using checksums.

--
Scott Ribe
scott_ribe@elevated-dev.com
(303) 722-0567

pgsql-admin by date:

Previous
From: David Steele
Date:
Subject: Re: [ADMIN] Does Postgres ever write to tables without file systemtimestamps getting updated?
Next
From: Harold Falkmeyer
Date:
Subject: Re: [ADMIN] VACUUM ANALYZE Issues