Alexandra Nitzschke napsal(a):
<snip>
>
> We went on with analyzing:
> - the table was created at 2008/01/03 17:56h
> - the nightly dump started at 2008/01/03 22:00h
> - it tried to copy the table 'adresse_080103' at 22:00:08
> - the dump crashed at 22:32:10 ( because of the error we reported
> 2007/12/14; we repaired the database not till 2008/01/11 )
>
> The stat of the database file returns this:
> File: "/postgres/database/data/base/23144/211593798"
> Size: 1835008 Blocks: 3592 IO Block: 4096 reguläre Datei
> Device: 811h/2065d Inode: 18121638 Links: 1
> Access: (0600/-rw-------) Uid: ( 1001/postgres) Gid: ( 2/ daemon)
> Access: 2008-02-15 18:19:44.000000000 +0100
> Modify: 2008-01-03 22:00:34.000000000 +0100
> Change: 2008-01-03 22:00:34.000000000 +0100
>
> We are wondering, that the pg_dump seems to have modified the file.
>
<snip>
>
> Could you please answer, if the pg_dump modifies the access timestamp in
> some cases?
>
Just a idea that pg_dump invoked checkpoint but I don't expect that
table data spent four hour in a buffer cache. Especially in case when
max checkpoint_timeout is one hour.
Zdenek
