Postgres Pro
Downloads
Home   >   mailing lists

Thread: WAL files not following sequence

WAL files not following sequence

From
German Becker
Date:
Hi all,

I have noticed a strange behaviour regarding WAL sequence numbers. I am populating a new DB with old data. To populate the largest part of the data I use wal_level=minimal and archive_mode=off. Then I stop the database and set wal_level=hotstandby and archive_mode=on. After I do that, I notice that the WAL sequence number "rewinds" a little bit, overlaping with the old ones... Is this normal?

Re: WAL files not following sequence

From
Amit Langote
Date:
On Wed, May 22, 2013 at 3:28 AM, German Becker <german.becker@gmail.com> wrote:
> Hi all,
>
> I have noticed a strange behaviour regarding WAL sequence numbers. I am
> populating a new DB with old data. To populate the largest part of the data
> I use wal_level=minimal and archive_mode=off. Then I stop the database and
> set wal_level=hotstandby and archive_mode=on. After I do that, I notice that
> the WAL sequence number "rewinds" a little bit, overlaping with the old
> ones... Is this normal?

can you show the output of "ls -l " for your pg_xlog?


--
Amit Langote

Re: WAL files not following sequence

From
Amit Langote
Date:
Hello,

Thanks for posting the output as I asked for. I could not immediately
understand what happened so I posted this to pgsql-hackers to let them
have a look at the issue, though I will reply if find anything
interesting.


--
Amit Langote

Re: WAL files not following sequence

From
Amit Langote
Date:
Hello,

Can you provide the output of following query?

select pg_xlogfile_name(pg_current_xlog_location());

--
Amit Langote

Re: WAL files not following sequence

From
Amit Langote
Date:
Hello,

I got response from pgsql-hackers that it is normal. In fact, the
newer segments that you see are pre-allocated ones (none of those
contain any valid WAL data as of now). And WAL data is currently being
written to an earlier segment like 000000010000000E00000080 (which
seems to be the latest in your "ls -lrt" output).

By the way, what are the values of following configuration parameters
for your cluster?

checkpoint_segments=?
checkpoint_timeout=?
archive_mode=?
archive_command=?


--
Amit Langote

Re: WAL files not following sequence

From
German Becker
Date:
Hi Amit,

Here it is (it's long)

postgres@lemur:~/9.1/main/pg_xlog$ ls -l
total 8421384
-rw------- 1 postgres postgres 16777216 May 21 12:27 000000010000000E0000007B
-rw------- 1 postgres postgres 16777216 May 21 12:35 000000010000000E0000007C
-rw------- 1 postgres postgres      276 May 21 12:35 000000010000000E0000007C.00000020.backup
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000007D
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000007E
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000007F
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000080
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000081
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000082
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000083
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000084
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000085
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000086
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000087
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000088
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000089
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000008A
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000008B
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000008C
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000008D
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000008E
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000008F
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000090
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000091
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000092
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000093
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000094
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000095
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000096
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000097
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000098
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000099
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000009A
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000009B
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000009C
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000009D
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000009E
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000009F
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E000000A0
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E000000A1
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E000000A2
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E000000A3
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E000000A4
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E000000A5
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E000000A6
-rw------- 1 postgres postgres 16777216 May 22 15:32 000000010000000E000000A7
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000E000000A8
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000E000000A9
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000E000000AA
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000E000000AB
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000E000000AC
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000E000000AD
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000E000000AE
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000E000000AF
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000E000000B0
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000E000000B1
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000E000000B2
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000E000000B3
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000E000000B4
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000E000000B5
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000E000000B6
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000E000000B7
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000E000000B8
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000E000000B9
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000E000000BA
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000E000000BB
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000E000000BC
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000E000000BD
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000E000000BE
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000E000000BF
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000E000000C0
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000E000000C1
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000E000000C2
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000E000000C3
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000E000000C4
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000E000000C5
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000E000000C6
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000E000000C7
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000E000000C8
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000E000000C9
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000E000000CA
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000E000000CB
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000E000000CC
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000E000000CD
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000E000000CE
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000E000000CF
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000E000000D0
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000E000000D1
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000E000000D2
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000E000000D3
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000E000000D4
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000E000000D5
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000E000000D6
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000E000000D7
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000E000000D8
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000E000000D9
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000E000000DA
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000E000000DB
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000E000000DC
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000E000000DD
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000E000000DE
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000E000000DF
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000E000000E0
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000E000000E1
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000E000000E2
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000E000000E3
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000E000000E4
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000E000000E5
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000E000000E6
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000E000000E7
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000E000000E8
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000E000000E9
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000E000000EA
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000E000000EB
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000E000000EC
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000E000000ED
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000E000000EE
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000E000000EF
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000E000000F0
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000E000000F1
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000E000000F2
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000E000000F3
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000E000000F4
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000E000000F5
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000E000000F6
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000E000000F7
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000E000000F8
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000E000000F9
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000E000000FA
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000E000000FB
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000E000000FC
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000E000000FD
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000E000000FE
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F00000000
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000F00000001
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000F00000002
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F00000003
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000004
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000F00000005
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000F00000006
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000F00000007
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000F00000008
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000F00000009
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F0000000A
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F0000000B
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F0000000C
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F0000000D
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F0000000E
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000F0000000F
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000010
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000F00000011
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000F00000012
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000F00000013
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000014
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F00000015
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000F00000016
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000017
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000F00000018
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F00000019
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F0000001A
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F0000001B
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F0000001C
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000F0000001D
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F0000001E
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F0000001F
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F00000020
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000021
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F00000022
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F00000023
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000024
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000F00000025
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F00000026
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F00000027
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000028
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F00000029
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F0000002A
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F0000002B
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F0000002C
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F0000002D
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F0000002E
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F0000002F
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000030
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000F00000031
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F00000032
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000F00000033
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F00000034
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F00000035
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000F00000036
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000037
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000038
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000F00000039
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F0000003A
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000F0000003B
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F0000003C
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F0000003D
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F0000003E
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F0000003F
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000F00000040
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000041
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000042
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000F00000043
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000044
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F00000045
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F00000046
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F00000047
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000048
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000049
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F0000004A
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F0000004B
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F0000004C
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F0000004D
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000F0000004E
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F0000004F
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F00000050
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F00000051
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000F00000052
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F00000053
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F00000054
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000055
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000F00000056
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000F00000057
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F00000058
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F00000059
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F0000005A
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F0000005B
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F0000005C
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F0000005D
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F0000005E
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F0000005F
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F00000060
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000061
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000F00000062
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000063
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F00000064
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F00000065
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000F00000066
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F00000067
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F00000068
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000F00000069
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F0000006A
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F0000006B
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F0000006C
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F0000006D
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F0000006E
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F0000006F
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000F00000070
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F00000071
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000F00000072
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F00000073
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000074
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000075
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F00000076
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F00000077
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000078
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000079
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F0000007A
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F0000007B
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F0000007C
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F0000007D
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F0000007E
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F0000007F
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000F00000080
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000F00000081
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000F00000082
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000F00000083
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000084
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000085
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000086
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F00000087
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000088
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000F00000089
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F0000008A
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F0000008B
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F0000008C
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000F0000008D
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F0000008E
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F0000008F
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000F00000090
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000F00000091
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F00000092
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F00000093
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000094
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000095
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000F00000096
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F00000097
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F00000098
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F00000099
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000F0000009A
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000F0000009B
-rw------- 1 postgres postgres 16777216 May 21 12:05 000000010000000F0000009C
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F0000009D
-rw------- 1 postgres postgres 16777216 May 21 12:09 000000010000000F0000009E
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F0000009F
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F000000A0
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F000000A1
-rw------- 1 postgres postgres 16777216 May 21 12:06 000000010000000F000000A2
-rw------- 1 postgres postgres 16777216 May 21 12:07 000000010000000F000000A3
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000A4
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000000F000000A5
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000000F000000A6
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000000F000000A7
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000A8
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000A9
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000000F000000AA
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000AB
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000AC
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F000000AD
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000AE
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000000F000000AF
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000B0
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000000F000000B1
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000000F000000B2
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000B3
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000B4
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000B5
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000000F000000B6
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000B7
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000000F000000B8
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000B9
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000BA
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000BB
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000BC
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000000F000000BD
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F000000BE
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000000F000000BF
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000000F000000C0
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000C1
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000C2
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000C3
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000000F000000C4
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000C5
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000C6
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000C7
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000C8
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F000000C9
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000CA
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000CB
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000CC
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000000F000000CD
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000CE
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000CF
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000D0
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000000F000000D1
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000D2
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000D3
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000D4
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000D5
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000D6
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F000000D7
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000D8
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000D9
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000000F000000DA
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000000F000000DB
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000000F000000DC
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000DD
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000000F000000DE
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000DF
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000E0
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000000F000000E1
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000E2
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000E3
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000E4
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000E5
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000E6
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000E7
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000E8
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000E9
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000EA
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000EB
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000000F000000EC
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000ED
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000EE
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000000F000000EF
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000F0
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F000000F1
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000F2
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000F3
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000000F000000F4
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000F5
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000F6
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000F7
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000F8
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000F9
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000FA
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000000F000000FB
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000FC
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000000F000000FD
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000FE
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000001000000000
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000001000000001
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000001000000002
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000001000000003
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000004
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000001000000005
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000001000000006
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000007
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000001000000008
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000009
-rw------- 1 postgres postgres 16777216 May 21 12:13 00000001000000100000000A
-rw------- 1 postgres postgres 16777216 May 21 12:13 00000001000000100000000B
-rw------- 1 postgres postgres 16777216 May 21 12:12 00000001000000100000000C
-rw------- 1 postgres postgres 16777216 May 21 12:13 00000001000000100000000D
-rw------- 1 postgres postgres 16777216 May 21 12:12 00000001000000100000000E
-rw------- 1 postgres postgres 16777216 May 21 12:12 00000001000000100000000F
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000010
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000001000000011
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000001000000012
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000001000000013
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000001000000014
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000001000000015
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000016
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000017
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000018
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000001000000019
-rw------- 1 postgres postgres 16777216 May 21 12:11 00000001000000100000001A
-rw------- 1 postgres postgres 16777216 May 21 12:13 00000001000000100000001B
-rw------- 1 postgres postgres 16777216 May 21 12:11 00000001000000100000001C
-rw------- 1 postgres postgres 16777216 May 21 12:10 00000001000000100000001D
-rw------- 1 postgres postgres 16777216 May 21 12:13 00000001000000100000001E
-rw------- 1 postgres postgres 16777216 May 21 12:13 00000001000000100000001F
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000020
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000001000000021
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000001000000022
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000023
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000001000000024
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000001000000025
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000001000000026
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000001000000027
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000028
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000001000000029
-rw------- 1 postgres postgres 16777216 May 21 12:10 00000001000000100000002A
-rw------- 1 postgres postgres 16777216 May 21 12:10 00000001000000100000002B
-rw------- 1 postgres postgres 16777216 May 21 12:11 00000001000000100000002C
-rw------- 1 postgres postgres 16777216 May 21 12:11 00000001000000100000002D
-rw------- 1 postgres postgres 16777216 May 21 12:13 00000001000000100000002E
-rw------- 1 postgres postgres 16777216 May 21 12:12 00000001000000100000002F
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000030
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000001000000031
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000032
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000001000000033
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000001000000034
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000001000000035
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000001000000036
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000001000000037
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000001000000038
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000001000000039
-rw------- 1 postgres postgres 16777216 May 21 12:10 00000001000000100000003A
-rw------- 1 postgres postgres 16777216 May 21 12:13 00000001000000100000003B
-rw------- 1 postgres postgres 16777216 May 21 12:12 00000001000000100000003C
-rw------- 1 postgres postgres 16777216 May 21 12:10 00000001000000100000003D
-rw------- 1 postgres postgres 16777216 May 21 12:10 00000001000000100000003E
-rw------- 1 postgres postgres 16777216 May 21 12:13 00000001000000100000003F
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000040
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000001000000041
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000042
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000043
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000001000000044
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000001000000045
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000001000000046
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000001000000047
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000048
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000001000000049
-rw------- 1 postgres postgres 16777216 May 21 12:11 00000001000000100000004A
-rw------- 1 postgres postgres 16777216 May 21 12:12 00000001000000100000004B
-rw------- 1 postgres postgres 16777216 May 21 12:12 00000001000000100000004C
-rw------- 1 postgres postgres 16777216 May 21 12:13 00000001000000100000004D
-rw------- 1 postgres postgres 16777216 May 21 12:13 00000001000000100000004E
-rw------- 1 postgres postgres 16777216 May 21 12:10 00000001000000100000004F
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000050
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000051
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000001000000052
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000001000000053
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000054
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000055
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000056
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000057
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000001000000058
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000001000000059
-rw------- 1 postgres postgres 16777216 May 21 12:12 00000001000000100000005A
-rw------- 1 postgres postgres 16777216 May 21 12:11 00000001000000100000005B
-rw------- 1 postgres postgres 16777216 May 21 12:13 00000001000000100000005C
-rw------- 1 postgres postgres 16777216 May 21 12:11 00000001000000100000005D
-rw------- 1 postgres postgres 16777216 May 21 12:11 00000001000000100000005E
-rw------- 1 postgres postgres 16777216 May 21 12:13 00000001000000100000005F
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000060
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000001000000061
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000062
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000001000000063
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000001000000064
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000001000000065
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000001000000066
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000001000000067
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000068
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000069
-rw------- 1 postgres postgres 16777216 May 21 12:13 00000001000000100000006A
-rw------- 1 postgres postgres 16777216 May 21 12:12 00000001000000100000006B
-rw------- 1 postgres postgres 16777216 May 21 12:10 00000001000000100000006C
-rw------- 1 postgres postgres 16777216 May 21 12:12 00000001000000100000006D
-rw------- 1 postgres postgres 16777216 May 21 12:11 00000001000000100000006E
-rw------- 1 postgres postgres 16777216 May 21 12:11 00000001000000100000006F
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000001000000070
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000001000000071
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000072
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000073
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000001000000074
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000001000000075
-rw------- 1 postgres postgres 16777216 May 21 12:10 000000010000001000000076
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000077
-rw------- 1 postgres postgres 16777216 May 21 12:12 000000010000001000000078
-rw------- 1 postgres postgres 16777216 May 21 12:11 000000010000001000000079
-rw------- 1 postgres postgres 16777216 May 21 12:11 00000001000000100000007A
-rw------- 1 postgres postgres 16777216 May 21 12:13 00000001000000100000007B
-rw------- 1 postgres postgres 16777216 May 21 12:11 00000001000000100000007C
-rw------- 1 postgres postgres 16777216 May 21 12:12 00000001000000100000007D
-rw------- 1 postgres postgres 16777216 May 21 12:12 00000001000000100000007E
drwx------ 2 postgres postgres     4096 May 21 14:53 archive_status


Here is the last part, sorting them by modification time (ls -lrt):

-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000B3
-rw------- 1 postgres postgres 16777216 May 21 12:13 00000001000000100000000A
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000001000000036
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000001000000008
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000F6
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000E4
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000F2
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000001000000003
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000D5
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000A9
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000D6
-rw------- 1 postgres postgres 16777216 May 21 12:13 00000001000000100000004E
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000D8
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000B4
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000BA
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000000F000000C3
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000001000000071
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000001000000047
-rw------- 1 postgres postgres 16777216 May 21 12:13 000000010000001000000026
-rw------- 1 postgres postgres 16777216 May 21 12:27 000000010000000E0000007B
-rw------- 1 postgres postgres 16777216 May 21 12:35 000000010000000E0000007C
-rw------- 1 postgres postgres      276 May 21 12:35 000000010000000E0000007C.00000020.backup
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000007D
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000007E
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000007F
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000080
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000081
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000082
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000083
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000084
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000085
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000086
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000087
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000088
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000089
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000008A
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000008B
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000008C
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000008D
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000008E
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000008F
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000090
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000091
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000092
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000093
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000094
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000095
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000096
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000097
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000098
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E00000099
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000009A
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000009B
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000009C
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000009D
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000009E
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E0000009F
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E000000A0
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E000000A1
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E000000A2
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E000000A3
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E000000A4
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E000000A5
-rw------- 1 postgres postgres 16777216 May 21 14:53 000000010000000E000000A6
drwx------ 2 postgres postgres     4096 May 21 14:53 archive_status
-rw------- 1 postgres postgres 16777216 May 22 15:37 000000010000000E000000A7

The first segment created after changing the wal_level parameter is 000000010000000E0000007B, since that the sequence continues, but it seems to overwrite the previous ones....


On Tue, May 21, 2013 at 9:19 PM, Amit Langote <amitlangote09@gmail.com> wrote:
On Wed, May 22, 2013 at 3:28 AM, German Becker <german.becker@gmail.com> wrote:
> Hi all,
>
> I have noticed a strange behaviour regarding WAL sequence numbers. I am
> populating a new DB with old data. To populate the largest part of the data
> I use wal_level=minimal and archive_mode=off. Then I stop the database and
> set wal_level=hotstandby and archive_mode=on. After I do that, I notice that
> the WAL sequence number "rewinds" a little bit, overlaping with the old
> ones... Is this normal?

can you show the output of "ls -l " for your pg_xlog?


--
Amit Langote