Hi All, Can this random order in archival of files be explained?
grep archived /var/log/localmessages 2008-05-23 08:43:43 PDTLOG: archived transaction log file "00000001000009BD0000009D" 2008-05-23 08:44:41 PDTLOG: archived transaction log file "00000001000009BD000000A0" <----- 9D and 9F archived much later 2008-05-23 08:45:01 PDTLOG: archived transaction log file "00000001000009BD000000A1" 2008-05-23 08:46:00 PDTLOG: archived transaction log file "00000001000009BD000000A4" 2008-05-23 08:46:26 PDTLOG: archived transaction log file "00000001000009BD0000006C" 2008-05-23 08:46:29 PDTLOG: archived transaction log file "00000001000009BD00000069" 2008-05-23 08:46:32 PDTLOG: archived transaction log file "00000001000009BD0000006D" 2008-05-23 08:46:33 PDTLOG: archived transaction log file "00000001000009BD00000071" 2008-05-23 08:46:34 PDTLOG: archived transaction log file "00000001000009BD00000073" 2008-05-23 08:46:35 PDTLOG: archived transaction log file "00000001000009BD00000074" 2008-05-23 08:46:38 PDTLOG: archived transaction log file "00000001000009BD00000075" 2008-05-23 08:46:41 PDTLOG: archived transaction log file "00000001000009BD00000076" 2008-05-23 08:46:42 PDTLOG: archived transaction log file "00000001000009BD00000077" 2008-05-23 08:46:43 PDTLOG: archived transaction log file "00000001000009BD0000007A" 2008-05-23 08:46:49 PDTLOG: archived transaction log file "00000001000009BD0000007B" 2008-05-23 08:46:52 PDTLOG: archived transaction log file "00000001000009BD0000007D" 2008-05-23 08:46:53 PDTLOG: archived transaction log file "00000001000009BD0000007F" 2008-05-23 08:46:54 PDTLOG: archived transaction log file "00000001000009BD000000A7" <--- chain broken here again... 2008-05-23 08:47:59 PDTLOG: archived transaction log file "00000001000009BD000000AA" 2008-05-23 08:48:21 PDTLOG: archived transaction log file "00000001000009BD000000AB" 2008-05-23 08:49:33 PDTLOG: archived transaction log file "00000001000009BD000000AD" 2008-05-23 08:50:30 PDTLOG: archived transaction log file "00000001000009BD000000AE" 2008-05-23 08:52:30 PDTLOG: archived transaction log file "00000001000009BD000000AF" 2008-05-23 08:54:30 PDTLOG: archived transaction log file "00000001000009BD000000B0" 2008-05-23 08:55:42 PDTLOG: archived transaction log file "00000001000009BD000000B1" 2008-05-23 08:57:39 PDTLOG: archived transaction log file "00000001000009BD000000B2" 2008-05-23 08:59:27 PDTLOG: archived transaction log file "00000001000009BD000000B3" 2008-05-23 09:01:26 PDTLOG: archived transaction log file "00000001000009BD00000085" 2008-05-23 09:01:27 PDTLOG: archived transaction log file "00000001000009BD00000080" 2008-05-23 09:01:28 PDTLOG: archived transaction log file "00000001000009BD00000081" 2008-05-23 09:01:29 PDTLOG: archived transaction log file "00000001000009BD00000086" 2008-05-23 09:01:30 PDTLOG: archived transaction log file "00000001000009BD00000088" 2008-05-23 09:01:34 PDTLOG: archived transaction log file "00000001000009BD00000089" 2008-05-23 09:01:37 PDTLOG: archived transaction log file "00000001000009BD0000008C" 2008-05-23 09:01:38 PDTLOG: archived transaction log file "00000001000009BD0000008F" 2008-05-23 09:01:39 PDTLOG: archived transaction log file "00000001000009BD00000090" 2008-05-23 09:01:42 PDTLOG: archived transaction log file "00000001000009BD00000091" 2008-05-23 09:01:46 PDTLOG: archived transaction log file "00000001000009BD00000093" 2008-05-23 09:01:47 PDTLOG: archived transaction log file "00000001000009BD00000094" 2008-05-23 09:01:48 PDTLOG: archived transaction log file "00000001000009BD00000095" 2008-05-23 09:01:52 PDTLOG: archived transaction log file "00000001000009BD00000097" 2008-05-23 09:01:54 PDTLOG: archived transaction log file "00000001000009BD00000099" 2008-05-23 09:01:55 PDTLOG: archived transaction log file "00000001000009BD0000009A" 2008-05-23 09:01:56 PDTLOG: archived transaction log file "00000001000009BD0000009B" 2008-05-23 09:01:57 PDTLOG: archived transaction log file "00000001000009BD0000009C" 2008-05-23 09:01:58 PDTLOG: archived transaction log file "00000001000009BD0000009E" 2008-05-23 09:01:59 PDTLOG: archived transaction log file "00000001000009BD0000009F" 2008-05-23 09:02:01 PDTLOG: archived transaction log file "00000001000009BD000000A2" 2008-05-23 09:02:04 PDTLOG: archived transaction log file "00000001000009BD000000A3" 2008-05-23 09:02:06 PDTLOG: archived transaction log file "00000001000009BD000000A5" 2008-05-23 09:02:06 PDTLOG: archived transaction log file "00000001000009BD000000B4" <--- continuing from where it left earlier!!! 2008-05-23 09:02:58 PDTLOG: archived transaction log file "00000001000009BD000000B5" 2008-05-23 09:04:32 PDTLOG: archived transaction log file "00000001000009BD000000B6" 2008-05-23 09:06:28 PDTLOG: archived transaction log file "00000001000009BD000000B7" 2008-05-23 09:08:21 PDTLOG: archived transaction log file "00000001000009BD000000B8" I always assumed that the XLogs are generated in sequence. Apparently, the hot-standby server is expecting and consuming the XLogs in-order, and not in the order they are being generated here! Best regards, -- [EMAIL PROTECTED] [EMAIL PROTECTED] gmail | hotmail | indiatimes | yahoo }.com EnterpriseDB http://www.enterprisedb.com Mail sent from my BlackLaptop device