From: scott ribe <scott_ribe@elevated-dev.com>
To: Thorsten Schöning <tschoening@am-soft.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: Does Postgres ever write to tables without file system timestamps getting updated?
Date: Tue, 6 Jun 2017 08:28:25 -0600
Message-ID: <FA191DE9-AE01-4E11-AD83-3E141D03743A@elevated-dev.com> (raw)
In-Reply-To: <1599962113.20170606153203@am-soft.de>
References: <143511646.20170606100454@am-soft.de>
<CB5E9FC3-94CE-4F12-B140-01E630474CD2@elevated-dev.com>
<1599962113.20170606153203@am-soft.de>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On Jun 6, 2017, at 7:32 AM, Thorsten Schöning <tschoening@am-soft.de> wrote:
>
> Obviously I wasn't clear enough: Postgres is not running and my
> problem is with files and their timestamps in the past. So regarding
> the timestamps the files didn't change for weeks and the files have
> the same size and timestamp in the source and my backup. But if I
> calculate hash sums of those files the results may differ, so rsync
> using checksums will back them up, although the files claim that they
> haven't changed for days/weeks.
You were clear, it's too early in the morning here.
You seem to be assuming that the files were changed close to the time you found the problem; as far as I can tell that's not actually true, they could have been changed back at the time of the file timestamps, and could have been out-of-sync for a while, right?
My suggestion to use pg_start_backup is irrelevant to the exact problem you're describing. The documentation for it does describe a good way to get a file-based backup, without stopping the server, and you might want to check into that. You could also look at pg_base_backup.
--
Scott Ribe
scott_ribe@elevated-dev.com
(303) 722-0567
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott_ribe@elevated-dev.com, tschoening@am-soft.de
Subject: Re: Does Postgres ever write to tables without file system timestamps getting updated?
In-Reply-To: <FA191DE9-AE01-4E11-AD83-3E141D03743A@elevated-dev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox