I'm seeing the following error in 7.4.6. It first surfaced after remounting a SAN mount from one box to another and then running 'vacuum full': pg_dump: ERROR: xlog flush request 68/7D853080 is not satisfied --- flushed only to 0/15A90A8 CONTEXT: writing block 34 of relation 17156/1470533 pg_dump: SQL command to dump the contents of table "patient_demographics" failed: PQendcopy() failed. pg_dump: Error message from server: ERROR: xlog flush request 68/7D853080 is not satisfied --- flushed only to 0/15A90A8 CONTEXT: writing block 34 of relation 17156/1470533 pg_dump: The command was: COPY public.customer... Here's my pg_controldata: $ pg_controldata pg_control version number: 72 Catalog version number: 200310211 Database cluster state: shutting down pg_control last modified: Mon Mar 6 13:26:19 2006 Current log file ID: 0 Next log file segment: 2 Latest checkpoint location: 0/151E9C8 Prior checkpoint location: 0/14DD760 Latest checkpoint's REDO location: 0/151E9C8 Latest checkpoint's UNDO location: 0/0 Latest checkpoint's StartUpID: 20 Latest checkpoint's NextXID: 2022907 Latest checkpoint's NextOID: 26923 Time of latest checkpoint: Mon Mar 6 13:05:11 2006 Database block size: 8192 Blocks per segment of large relation: 131072 Maximum length of identifiers: 64 Maximum number of function arguments: 32 Date/time type storage: floating-point numbers Maximum length of locale name: 128 LC_COLLATE: C LC_CTYPE: C Here's my pg_xlog directory: -rw------- 1 cudba cu 16777216 Mar 6 08:25 000000680000007F -rw------- 1 cudba cu 16777216 Mar 6 08:51 0000006800000080 -rw------- 1 cudba cu 16777216 Mar 6 09:09 0000006800000081 -rw------- 1 cudba cu 16777216 Mar 6 09:20 0000006800000082 -rw------- 1 cudba cu 16777216 Mar 6 09:30 0000006800000083 -rw------- 1 cudba cu 16777216 Mar 6 09:45 0000006800000084 -rw------- 1 cudba cu 16777216 Mar 6 10:00 0000006800000085 -rw------- 1 cudba cu 16777216 Mar 6 10:10 000000680000007E -rw------- 1 cudba cu 16777216 Mar 6 13:21 0000000000000001 I have pg_filedump built. Any clues on how to tweak this file to restore full access while minimizing data loss? Thanks, Ed
