WAL Sequence

From: Ashish Karalkar <ashish_postgre(at)yahoo(dot)co(dot)in>
To: pggeneral <pgsql-general(at)postgresql(dot)org>, ashish(dot)karalkar(at)netcore(dot)co(dot)in
Subject: WAL Sequence
Date: 2008-01-07 09:57:44
Message-ID: 397194.90119.qm@web94305.mail.in2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tomasz Ostrowski 2008-01-07 10:20:29 Re: basic questions: Postgres with yum on CentOS 5.1
Previous Message mljv 2008-01-07 09:32:26 Memory on 32bit machine