Re: [ADMIN] Does Postgres ever write to tables without file systemtimestamps getting updated?

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'snot actually true, they could have been changed back at the time of the file timestamps, and could have been
out-of-syncfor a while, right? 

My suggestion to use pg_start_backup is irrelevant to the exact problem you're describing. The documentation for it
doesdescribe a good way to get a file-based backup, without stopping the server, and you might want to check into that.
Youcould also look at pg_base_backup. 

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