Dear list member: I have small problem, below is the output from ls -larth command for listing WAL segments. As far as my understanding every new WAL segment created is numerically greater than the previous one,but below out show the WAL 13 is created after wal 14,15,16,17,18,19 checked by creation time.
Can anybody please suggest me is ther anything going wrong or am i just doing something silly. :) OS:Suse 10.3 64 bit,PostgreSQL server:8.2.4 $ ls -alrth total 129M -rw------- 1 postgres postgres 269 2008-01-06 23:59 000000010000001700000003.00010588.backup drwx------ 11 postgres postgres 4.0K 2008-01-06 23:59 .. -rw------- 1 postgres postgres 16M 2008-01-07 08:59 000000010000001700000014 -rw------- 1 postgres postgres 16M 2008-01-07 09:59 000000010000001700000015 -rw------- 1 postgres postgres 16M 2008-01-07 10:59 000000010000001700000016 -rw------- 1 postgres postgres 16M 2008-01-07 11:59 000000010000001700000017 -rw------- 1 postgres postgres 16M 2008-01-07 12:59 000000010000001700000018 -rw------- 1 postgres postgres 16M 2008-01-07 13:59 000000010000001700000019 -rw------- 1 postgres postgres 16M 2008-01-07 14:59 00000001000000170000001A drwxr-xr-x 2 postgres postgres 4.0K 2008-01-07 15:09 archive_status drwxr-xr-x 3 postgres postgres 4.0K 2008-01-07 15:09 . -rw------- 1 postgres postgres 16M 2008-01-07 15:15 000000010000001700000013 With Regards Ashish --------------------------------- Chat on a cool, new interface. No download required. Click here.