Re: Does Postgres ever write to tables without file system timestamps getting updated?

From: scott ribe <scott_ribe(at)elevated-dev(dot)com>
To: David Steele <david(at)pgmasters(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Does Postgres ever write to tables without file system timestamps getting updated?
Date: 2017-06-06 16:23:02
Message-ID: 56559FCA-392D-4F38-8A15-C220892C46C3@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

To be clear, for potential future readers, just using checksum is not enough to back up a live database. You still have to use pg_start_backup and pay attention to its documentation re WAL files.

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

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
(303) 722-0567

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Harold Falkmeyer 2017-06-06 18:43:22 Re: VACUUM ANALYZE Issues
Previous Message David Steele 2017-06-06 14:54:13 Re: Does Postgres ever write to tables without file system timestamps getting updated?