Обсуждение: BUG #16317: max_wal_size does not remove WAL files, cause "no space left"

Поиск
Список
Период
Сортировка

BUG #16317: max_wal_size does not remove WAL files, cause "no space left"

От
PG Bug reporting form
Дата:
The following bug has been logged on the website:

Bug reference:      16317
Logged by:          Fan Liu
Email address:      fan.liu@ericsson.com
PostgreSQL version: 10.10
Operating system:   suse
Description:

Hello,

We are working on PostgreSQL 10.10. We recently met “no space left”.
After checking, the WAL file folder is full. There is no heavy traffic.
But we have wal_max_size = 1G configured. I am not that understand why this
can happen. 
Is this a BUG? 

=== LOG ===
## /var/lib/postgresql/data is a network storage with 4G space

pg-0:/var/lib/postgresql/data/pgdata/pg_wal # ls -alh
total 3.9G
drwx------  3 postgres postgres  20K Mar 21 02:31 .
drwx------ 19 postgres postgres 4.0K Mar 21 02:31 ..
-rw-------  1 postgres postgres  16M Feb 20 14:05

eric-adp-ss7-db-pg-0:/var/lib/postgresql/data/pgdata # du -h -d1
3.9G    ./pg_wal
600K    ./global
…..
3.9G    .

cat postgresql.conf
# Do not edit this file manually!
# It will be overwritten by Patroni!
include 'postgresql.base.conf'

cluster_name = 'ss7-db-pg'
hot_standby = 'on'
listen_addresses = '*'
logging_collector = 'off'
max_connections = '100'
max_locks_per_transaction = '64'
max_prepared_transactions = '0'
max_replication_slots = '10'
max_wal_senders = '10'
max_worker_processes = '8'
port = '5432'
track_commit_timestamp = 'off'
wal_keep_segments = '8'
wal_level = 'replica'
wal_log_hints = 'on'
hba_file = '/var/lib/postgresql/data/pgdata/pg_hba.conf'
ident_file = '/var/lib/postgresql/data/pgdata/pg_ident.conf'

postgres=# SHOW max_wal_size;
max_wal_size
--------------
1GB
(1 row)

BRs,
Fan Liu


Re: BUG #16317: max_wal_size does not remove WAL files, cause "nospace left"

От
hubert depesz lubaczewski
Дата:
On Wed, Mar 25, 2020 at 11:11:11AM +0000, PG Bug reporting form wrote:
> eric-adp-ss7-db-pg-0:/var/lib/postgresql/data/pgdata # du -h -d1
> 3.9G    ./pg_wal
> 600K    ./global
> …..
> 3.9G    .
> 
> postgres=# SHOW max_wal_size;
> max_wal_size
> --------------
> 1GB
> (1 row)

Please show us:
show archive_mode;
show archive_command;
select * from pg_stat_replication;
select * from pg_replication_slots;
select pg_current_wal_lsn();

and, from postgres account in shell:
ps uwwxf | grep -C3 archive

Best regards,

depesz




RE: BUG #16317: max_wal_size does not remove WAL files, cause "nospace left"

От
Fan Liu
Дата:
-----Original Message-----
From: depesz@depesz.com <depesz@depesz.com> 
Sent: 2020年3月25日 19:39
To: Fan Liu <fan.liu@ericsson.com>; pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16317: max_wal_size does not remove WAL files, cause "no space left"

On Wed, Mar 25, 2020 at 11:11:11AM +0000, PG Bug reporting form wrote:
> eric-adp-ss7-db-pg-0:/var/lib/postgresql/data/pgdata # du -h -d1
> 3.9G    ./pg_wal
> 600K    ./global
> …..
> 3.9G    .
> 
> postgres=# SHOW max_wal_size;
> max_wal_size
> --------------
> 1GB
> (1 row)

Please show us:
show archive_mode;
show archive_command;
select * from pg_stat_replication;
select * from pg_replication_slots;
select pg_current_wal_lsn();

and, from postgres account in shell:
ps uwwxf | grep -C3 archive

Best regards,

depesz
---------------------------------

Hi Depesz,
Here is the log. 

ss7-db-pg-1:/ # psql -U postgres
psql (10.10)
Type "help" for help.

postgres=# show archive_mode;
 archive_mode
--------------
 off
(1 row)

postgres=# show archive_command;
 archive_command
-----------------
 (disabled)
(1 row)

postgres=# select * from pg_stat_replication;
  pid  | usesysid | usename |   application_name   |   client_addr   | client_hostname | client_port |
backend_start        | backend_xmin |   state   | sent_lsn  | write_lsn | flush_lsn | replay_lsn | write_lag |
flush_lag| rep
 
lay_lag | sync_priority | sync_state

-------+----------+---------+----------------------+-----------------+-----------------+-------------+-------------------------------+--------------+-----------+-----------+-----------+-----------+------------+-----------+-----------+----
--------+---------------+------------
 39252 |    16398 | replica | eric-adp-ss7-db-pg-2 | 192.168.187.43  |                 |       55926 | 2020-03-25
10:37:52.992757+00|              | streaming | 0/51207A8 | 0/51207A8 | 0/51207A8 | 0/51207A8  |           |
|
        |             1 | sync
 39253 |    16398 | replica | eric-adp-ss7-db-pg-0 | 192.168.254.251 |                 |       57518 | 2020-03-25
10:37:52.993196+00|              | streaming | 0/51207A8 | 0/51207A8 | 0/51207A8 | 0/51207A8  |           |
|
        |             0 | async
(2 rows)

postgres=# select * from pg_replication_slots;
      slot_name       | plugin | slot_type | datoid | database | temporary | active | active_pid | xmin | catalog_xmin
|restart_lsn | confirmed_flush_lsn
 

----------------------+--------+-----------+--------+----------+-----------+--------+------------+------+--------------+-------------+---------------------
 eric_adp_ss7_db_pg_2 |        | physical  |        |          | f         | t      |      39252 |      |
|0/51207A8   |
 
 eric_adp_ss7_db_pg_0 |        | physical  |        |          | f         | t      |      39253 |      |
|0/51207A8   |
 
(2 rows)

postgres=# select pg_current_wal_lsn();
 pg_current_wal_lsn
--------------------
 0/51207A8
(1 row)

postgres=# ps uwwxf | grep -C3 archive
postgres-# \q
ss7-db-pg-1:/ # ps uwwxf | grep -C3 archive
USER        PID %CPU %MEM    VSZ   RSS TTY      STAT START   TIME COMMAND
root      52808  0.0  0.0  18572  5108 pts/0    Ss   11:39   0:00 bash
root      54898  0.0  0.0  36504  1752 pts/0    R+   11:49   0:00  \_ ps uwwxf
root      54899  0.0  0.0   8712   968 pts/0    S+   11:49   0:00  \_ grep -C3 archive
ss7-db-pg-1:/ #

BRs,
Fan Liu

RE: BUG #16317: max_wal_size does not remove WAL files, cause "nospace left"

От
Fan Liu
Дата:
>>-----Original Message-----
>>From: Fan Liu 
>>Sent: 2020年3月25日 19:52
>>To: depesz@depesz.com; pgsql-bugs@lists.postgresql.org
>>Subject: RE: BUG #16317: max_wal_size does not remove WAL files, cause "no space left"
>>
>>-----Original Message-----
>>From: depesz@depesz.com <depesz@depesz.com> 
>>Sent: 2020年3月25日 19:39
>>To: Fan Liu <fan.liu@ericsson.com>; pgsql-bugs@lists.postgresql.org
>>Subject: Re: BUG #16317: max_wal_size does not remove WAL files, cause "no space left"
>>
>>On Wed, Mar 25, 2020 at 11:11:11AM +0000, PG Bug reporting form wrote:
>>> eric-adp-ss7-db-pg-0:/var/lib/postgresql/data/pgdata # du -h -d1
>>> 3.9G    ./pg_wal
>>> 600K    ./global
>>> …..
>>> 3.9G    .
>>> 
>>> postgres=# SHOW max_wal_size;
>>> max_wal_size
>>> --------------
>>> 1GB
>>> (1 row)
>>
>>Please show us:
>>show archive_mode;
>>show archive_command;
>>select * from pg_stat_replication;
>>select * from pg_replication_slots;
>>select pg_current_wal_lsn();
>>
>>and, from postgres account in shell:
>>ps uwwxf | grep -C3 archive
>>
>>Best regards,
>>
>>depesz
>>---------------------------------
>>
>>Hi Depesz,
>>Here is the log. 
>>
>>ss7-db-pg-1:/ # psql -U postgres
>>psql (10.10)
>>Type "help" for help.
>>
>>postgres=# show archive_mode;
>> archive_mode
>>--------------
>> off
>>(1 row)
>>
>>postgres=# show archive_command;
>> archive_command
>>-----------------
>> (disabled)
>>(1 row)
>>
>>postgres=# select * from pg_stat_replication;
>>  pid  | usesysid | usename |   application_name   |   client_addr   | client_hostname | client_port |
backend_start        | backend_xmin |   state   | sent_lsn  | write_lsn | flush_lsn | replay_lsn | write_lag |
flush_lag| rep
 
>>lay_lag | sync_priority | sync_state

>>-------+----------+---------+----------------------+-----------------+-----------------+-------------+-------------------------------+--------------+-----------+-----------+-----------+-----------+------------+-----------+-----------+----
>>--------+---------------+------------
>> 39252 |    16398 | replica | eric-adp-ss7-db-pg-2 | 192.168.187.43  |                 |       55926 | 2020-03-25
10:37:52.992757+00|              | streaming | 0/51207A8 | 0/51207A8 | 0/51207A8 | 0/51207A8  |           |
|
>>        |             1 | sync
>> 39253 |    16398 | replica | eric-adp-ss7-db-pg-0 | 192.168.254.251 |                 |       57518 | 2020-03-25
10:37:52.993196+00|              | streaming | 0/51207A8 | 0/51207A8 | 0/51207A8 | 0/51207A8  |           |
|
>>        |             0 | async
>>(2 rows)
>>
>>postgres=# select * from pg_replication_slots;
>>      slot_name       | plugin | slot_type | datoid | database | temporary | active | active_pid | xmin |
catalog_xmin| restart_lsn | confirmed_flush_lsn
 

>>----------------------+--------+-----------+--------+----------+-----------+--------+------------+------+--------------+-------------+---------------------
>> eric_adp_ss7_db_pg_2 |        | physical  |        |          | f         | t      |      39252 |      |
| 0/51207A8   |
 
>> eric_adp_ss7_db_pg_0 |        | physical  |        |          | f         | t      |      39253 |      |
| 0/51207A8   |
 
>>(2 rows)
>>
>>postgres=# select pg_current_wal_lsn();
>> pg_current_wal_lsn
>>--------------------
>> 0/51207A8
>>(1 row)
>>
>>postgres=# ps uwwxf | grep -C3 archive
>>postgres-# \q
>>ss7-db-pg-1:/ # ps uwwxf | grep -C3 archive
>>USER        PID %CPU %MEM    VSZ   RSS TTY      STAT START   TIME COMMAND
>>root      52808  0.0  0.0  18572  5108 pts/0    Ss   11:39   0:00 bash
>>root      54898  0.0  0.0  36504  1752 pts/0    R+   11:49   0:00  \_ ps uwwxf
>>root      54899  0.0  0.0   8712   968 pts/0    S+   11:49   0:00  \_ grep -C3 archive
>>ss7-db-pg-1:/ #
>>
>>BRs,
>>Fan Liu
>>

More logs

ss7-db-pg-1:/var/lib/postgresql/data/pgdata # pg_controldata -D .
pg_control version number:            1002
Catalog version number:               201707211
Database system identifier:           6795532438034051129
Database cluster state:               in production
pg_control last modified:             Wed 25 Mar 2020 10:42:49 AM UTC
Latest checkpoint location:           0/5120700
Prior checkpoint location:            0/5120620
Latest checkpoint's REDO location:    0/51206C8
Latest checkpoint's REDO WAL file:    000000E90000000000000005
Latest checkpoint's TimeLineID:       233
Latest checkpoint's PrevTimeLineID:   233
Latest checkpoint's full_page_writes: on
Latest checkpoint's NextXID:          0:665
Latest checkpoint's NextOID:          24596
Latest checkpoint's NextMultiXactId:  1
Latest checkpoint's NextMultiOffset:  0
Latest checkpoint's oldestXID:        549
Latest checkpoint's oldestXID's DB:   1
Latest checkpoint's oldestActiveXID:  665
Latest checkpoint's oldestMultiXid:   1
Latest checkpoint's oldestMulti's DB: 1
Latest checkpoint's oldestCommitTsXid:0
Latest checkpoint's newestCommitTsXid:0
Time of latest checkpoint:            Wed 25 Mar 2020 10:42:49 AM UTC
Fake LSN counter for unlogged rels:   0/1
Minimum recovery ending location:     0/0
Min recovery ending loc's timeline:   0
Backup start location:                0/0
Backup end location:                  0/0
End-of-backup record required:        no
wal_level setting:                    replica
wal_log_hints setting:                on
max_connections setting:              100
max_worker_processes setting:         8
max_prepared_xacts setting:           0
max_locks_per_xact setting:           64
track_commit_timestamp setting:       off
Maximum data alignment:               8
Database block size:                  8192
Blocks per segment of large relation: 131072
WAL block size:                       8192
Bytes per WAL segment:                16777216
Maximum length of identifiers:        64
Maximum columns in an index:          32
Maximum size of a TOAST chunk:        1996
Size of a large-object chunk:         2048
Date/time type storage:               64-bit integers
Float4 argument passing:              by value
Float8 argument passing:              by value
Data page checksum version:           1
Mock authentication nonce:            bc46d88b034161423b3a4f0ca2e2b42f0d41c9654b3bef9716f850a412d51557

ss7-db-pg-1:/var/lib/postgresql/data/pgdata # pg_archivecleanup -d pg_wal 000000E90000000000000005
pg_archivecleanup: keeping WAL file "pg_wal/000000E90000000000000005" and later

ss7-db-pg-1:/var/lib/postgresql/data/pgdata # du -h pg_wal/
16K     pg_wal/archive_status
3.7G    pg_wal/

BRs,
Fan Liu

Re: BUG #16317: max_wal_size does not remove WAL files, cause "nospace left"

От
hubert depesz lubaczewski
Дата:
On Wed, Mar 25, 2020 at 12:26:22PM +0000, Fan Liu wrote:
> >>postgres=# ps uwwxf | grep -C3 archive
> >>postgres-# \q
> >>ss7-db-pg-1:/ # ps uwwxf | grep -C3 archive

I asked for this ps/grep from shell of postgres. not from psql as
postgres, and not from root shell.

But it's not really important.

can you show me:

select pg_walfile_name( pg_current_wal_lsn());

and then, as postgres:
cd /var/lib/postgresql/data/pgdata/wal (or wherever wal is), and do:
ls -l

and show us the output (possiblky using some paste site).

Best regards,

depesz




RE: BUG #16317: max_wal_size does not remove WAL files, cause "nospace left"

От
Fan Liu
Дата:

>-----Original Message-----

>From: depesz@depesz.com <depesz@depesz.com>

>Sent: 2020325 23:05

>To: Fan Liu <fan.liu@ericsson.com>

>Cc: pgsql-bugs@lists.postgresql.org

>Subject: Re: BUG #16317: max_wal_size does not remove WAL files, cause "no space left"

>On Wed, Mar 25, 2020 at 12:26:22PM +0000, Fan Liu wrote:

>> >>postgres=# ps uwwxf | grep -C3 archive postgres-# \q ss7-db-pg-1:/ #

>> >>ps uwwxf | grep -C3 archive

>I asked for this ps/grep from shell of postgres. not from psql as postgres, and not from root shell.

>But it's not really important.

>can you show me:

>select pg_walfile_name( pg_current_wal_lsn());

>and then, as postgres:

>cd /var/lib/postgresql/data/pgdata/wal (or wherever wal is), and do:

>ls -l

>and show us the output (possiblky using some paste site).

>Best regards,

>depesz

 

Hi,

 

We are working on K8s. I can't connect to master node today, it start to circle reboot.

I can still connect to replica node, they are "no space left" and not working as well. But no circle reboot yet.

 

So, I can only provide the printout from replica node. But they should be same or close.

 

The part I am not understand is that WAL files are not cyclical with max_wal_size=1G, what kind of scenario will cause this?

 

total 4015872

drwx------  3 postgres postgres    20480 Mar 25 19:23 .

drwx------ 19 postgres postgres     4096 Mar 25 23:23 ..

-rw-------  1 postgres postgres 16777216 Feb 20 14:17 000000010000000000000001

-rw-------  1 postgres postgres 16777216 Feb 20 14:17 000000010000000000000002

-rw-------  1 postgres postgres 16777216 Feb 20 14:17 000000010000000000000003

-rw-------  1 postgres postgres 16777216 Feb 20 14:17 000000010000000000000004

-rw-------  1 postgres postgres 16777216 Feb 20 14:46 000000010000000000000005

-rw-------  1 postgres postgres 16777216 Feb 20 15:02 000000020000000000000005

-rw-------  1 postgres postgres       41 Feb 20 14:46 00000002.history

-rw-------  1 postgres postgres 16777216 Feb 20 22:04 000000030000000000000005

-rw-------  1 postgres postgres       83 Feb 20 15:02 00000003.history

-rw-------  1 postgres postgres 16777216 Feb 20 23:32 000000040000000000000005

-rw-------  1 postgres postgres      125 Feb 20 22:04 00000004.history

-rw-------  1 postgres postgres 16777216 Feb 20 23:39 000000050000000000000005

-rw-------  1 postgres postgres      167 Feb 20 23:32 00000005.history

-rw-------  1 postgres postgres 16777216 Feb 21 01:34 000000060000000000000005

-rw-------  1 postgres postgres      209 Feb 20 23:39 00000006.history

-rw-------  1 postgres postgres 16777216 Feb 21 09:29 000000070000000000000005

-rw-------  1 postgres postgres      251 Feb 21 01:35 00000007.history

-rw-------  1 postgres postgres 16777216 Feb 21 09:36 000000080000000000000005

-rw-------  1 postgres postgres      293 Feb 21 09:29 00000008.history

-rw-------  1 postgres postgres 16777216 Feb 21 10:54 000000090000000000000005

-rw-------  1 postgres postgres      335 Feb 21 09:37 00000009.history

-rw-------  1 postgres postgres 16777216 Feb 21 12:28 0000000A0000000000000005

-rw-------  1 postgres postgres      377 Feb 21 10:54 0000000A.history

-rw-------  1 postgres postgres 16777216 Feb 21 12:35 0000000B0000000000000005

-rw-------  1 postgres postgres      420 Feb 21 12:28 0000000B.history

-rw-------  1 postgres postgres 16777216 Feb 21 13:41 0000000C0000000000000005

-rw-------  1 postgres postgres      463 Feb 21 12:35 0000000C.history

-rw-------  1 postgres postgres 16777216 Feb 21 14:09 0000000D0000000000000005

-rw-------  1 postgres postgres      506 Feb 21 13:41 0000000D.history

-rw-------  1 postgres postgres 16777216 Feb 21 14:16 0000000E0000000000000005

-rw-------  1 postgres postgres      549 Feb 21 14:09 0000000E.history

-rw-------  1 postgres postgres 16777216 Feb 21 14:41 0000000F0000000000000005

-rw-------  1 postgres postgres      592 Feb 21 14:16 0000000F.history

-rw-------  1 postgres postgres 16777216 Feb 21 15:29 000000100000000000000005

-rw-------  1 postgres postgres      635 Feb 21 14:41 00000010.history

-rw-------  1 postgres postgres 16777216 Feb 21 15:59 000000110000000000000005

-rw-------  1 postgres postgres      678 Feb 21 15:30 00000011.history

-rw-------  1 postgres postgres 16777216 Feb 21 16:26 000000120000000000000005

-rw-------  1 postgres postgres      721 Feb 21 16:00 00000012.history

-rw-------  1 postgres postgres 16777216 Feb 21 17:00 000000130000000000000005

-rw-------  1 postgres postgres      764 Feb 21 16:26 00000013.history

-rw-------  1 postgres postgres 16777216 Feb 21 17:45 000000140000000000000005

-rw-------  1 postgres postgres      807 Feb 21 17:00 00000014.history

-rw-------  1 postgres postgres 16777216 Feb 21 21:36 000000150000000000000005

-rw-------  1 postgres postgres      850 Feb 21 17:46 00000015.history

-rw-------  1 postgres postgres 16777216 Feb 22 13:39 000000160000000000000005

-rw-------  1 postgres postgres      893 Feb 21 21:37 00000016.history

-rw-------  1 postgres postgres 16777216 Feb 23 10:29 000000170000000000000005

-rw-------  1 postgres postgres      936 Feb 22 13:39 00000017.history

-rw-------  1 postgres postgres 16777216 Feb 23 10:36 000000180000000000000005

-rw-------  1 postgres postgres      979 Feb 23 10:29 00000018.history

-rw-------  1 postgres postgres 16777216 Feb 24 08:34 000000190000000000000005

-rw-------  1 postgres postgres     1022 Feb 23 10:37 00000019.history

-rw-------  1 postgres postgres 16777216 Feb 24 09:10 0000001A0000000000000005

-rw-------  1 postgres postgres     1065 Feb 24 08:35 0000001A.history

-rw-------  1 postgres postgres 16777216 Feb 24 10:10 0000001B0000000000000005

-rw-------  1 postgres postgres     1108 Feb 24 09:11 0000001B.history

-rw-------  1 postgres postgres 16777216 Feb 24 10:17 0000001C0000000000000005

-rw-------  1 postgres postgres     1151 Feb 24 10:10 0000001C.history

-rw-------  1 postgres postgres 16777216 Feb 24 13:09 0000001D0000000000000005

-rw-------  1 postgres postgres     1194 Feb 24 10:18 0000001D.history

-rw-------  1 postgres postgres 16777216 Feb 24 13:43 0000001E0000000000000005

-rw-------  1 postgres postgres     1237 Feb 24 13:10 0000001E.history

-rw-------  1 postgres postgres 16777216 Feb 24 16:32 0000001F0000000000000005

-rw-------  1 postgres postgres     1280 Feb 24 13:43 0000001F.history

-rw-------  1 postgres postgres 16777216 Feb 24 23:14 000000200000000000000005

-rw-------  1 postgres postgres     1323 Feb 24 16:32 00000020.history

-rw-------  1 postgres postgres 16777216 Feb 25 01:31 000000210000000000000005

-rw-------  1 postgres postgres     1366 Feb 24 23:14 00000021.history

-rw-------  1 postgres postgres 16777216 Feb 25 01:38 000000220000000000000005

-rw-------  1 postgres postgres     1409 Feb 25 01:31 00000022.history

-rw-------  1 postgres postgres 16777216 Feb 25 03:38 000000230000000000000005

-rw-------  1 postgres postgres     1452 Feb 25 01:38 00000023.history

-rw-------  1 postgres postgres 16777216 Feb 25 08:55 000000240000000000000005

-rw-------  1 postgres postgres     1495 Feb 25 03:38 00000024.history

-rw-------  1 postgres postgres 16777216 Feb 25 09:05 000000250000000000000005

-rw-------  1 postgres postgres     1538 Feb 25 08:55 00000025.history

-rw-------  1 postgres postgres 16777216 Feb 25 09:37 000000260000000000000005

-rw-------  1 postgres postgres     1581 Feb 25 09:05 00000026.history

-rw-------  1 postgres postgres 16777216 Feb 25 11:16 000000270000000000000005

-rw-------  1 postgres postgres     1624 Feb 25 09:38 00000027.history

-rw-------  1 postgres postgres 16777216 Feb 25 11:42 000000280000000000000005

-rw-------  1 postgres postgres     1667 Feb 25 11:17 00000028.history

-rw-------  1 postgres postgres 16777216 Feb 25 12:32 000000290000000000000005

-rw-------  1 postgres postgres     1710 Feb 25 11:42 00000029.history

-rw-------  1 postgres postgres 16777216 Feb 25 12:53 0000002A0000000000000005

-rw-------  1 postgres postgres     1753 Feb 25 12:32 0000002A.history

-rw-------  1 postgres postgres 16777216 Feb 25 19:01 0000002B0000000000000005

-rw-------  1 postgres postgres     1796 Feb 25 12:53 0000002B.history

-rw-------  1 postgres postgres 16777216 Feb 25 19:16 0000002C0000000000000005

-rw-------  1 postgres postgres     1839 Feb 25 19:02 0000002C.history

-rw-------  1 postgres postgres 16777216 Feb 25 19:19 0000002D0000000000000005

-rw-------  1 postgres postgres     1882 Feb 25 19:16 0000002D.history

-rw-------  1 postgres postgres 16777216 Feb 25 20:05 0000002E0000000000000005

-rw-------  1 postgres postgres     1925 Feb 25 19:19 0000002E.history

-rw-------  1 postgres postgres 16777216 Feb 25 20:26 0000002F0000000000000005

-rw-------  1 postgres postgres     1968 Feb 25 20:05 0000002F.history

-rw-------  1 postgres postgres 16777216 Feb 26 07:04 000000300000000000000005

-rw-------  1 postgres postgres     2011 Feb 25 20:26 00000030.history

-rw-------  1 postgres postgres 16777216 Feb 26 08:29 000000310000000000000005

-rw-------  1 postgres postgres     2054 Feb 26 07:04 00000031.history

-rw-------  1 postgres postgres 16777216 Feb 26 09:01 000000320000000000000005

-rw-------  1 postgres postgres     2097 Feb 26 08:29 00000032.history

-rw-------  1 postgres postgres 16777216 Feb 26 10:22 000000330000000000000005

-rw-------  1 postgres postgres     2140 Feb 26 09:01 00000033.history

-rw-------  1 postgres postgres 16777216 Feb 26 10:53 000000340000000000000005

-rw-------  1 postgres postgres     2183 Feb 26 10:22 00000034.history

-rw-------  1 postgres postgres 16777216 Feb 26 11:00 000000350000000000000005

-rw-------  1 postgres postgres     2226 Feb 26 10:53 00000035.history

-rw-------  1 postgres postgres 16777216 Feb 26 12:34 000000360000000000000005

-rw-------  1 postgres postgres     2269 Feb 26 11:00 00000036.history

-rw-------  1 postgres postgres 16777216 Feb 26 13:53 000000370000000000000005

-rw-------  1 postgres postgres     2312 Feb 26 12:34 00000037.history

-rw-------  1 postgres postgres 16777216 Feb 26 14:00 000000380000000000000005

-rw-------  1 postgres postgres     2355 Feb 26 13:53 00000038.history

-rw-------  1 postgres postgres 16777216 Feb 26 14:30 000000390000000000000005

-rw-------  1 postgres postgres     2398 Feb 26 14:00 00000039.history

-rw-------  1 postgres postgres 16777216 Feb 26 16:07 0000003A0000000000000005

-rw-------  1 postgres postgres     2441 Feb 26 14:30 0000003A.history

-rw-------  1 postgres postgres 16777216 Feb 26 16:15 0000003B0000000000000005

-rw-------  1 postgres postgres     2484 Feb 26 16:07 0000003B.history

-rw-------  1 postgres postgres 16777216 Feb 26 16:40 0000003C0000000000000005

-rw-------  1 postgres postgres     2527 Feb 26 16:15 0000003C.history

-rw-------  1 postgres postgres 16777216 Feb 26 17:23 0000003D0000000000000005

-rw-------  1 postgres postgres     2570 Feb 26 16:40 0000003D.history

-rw-------  1 postgres postgres 16777216 Feb 26 18:00 0000003E0000000000000005

-rw-------  1 postgres postgres     2613 Feb 26 17:23 0000003E.history

-rw-------  1 postgres postgres 16777216 Feb 26 20:02 0000003F0000000000000005

-rw-------  1 postgres postgres     2656 Feb 26 18:00 0000003F.history

-rw-------  1 postgres postgres 16777216 Feb 26 20:11 000000400000000000000005

-rw-------  1 postgres postgres     2699 Feb 26 20:02 00000040.history

-rw-------  1 postgres postgres 16777216 Feb 26 21:13 000000410000000000000005

-rw-------  1 postgres postgres     2742 Feb 26 20:11 00000041.history

-rw-------  1 postgres postgres 16777216 Feb 26 22:00 000000420000000000000005

-rw-------  1 postgres postgres     2785 Feb 26 21:13 00000042.history

-rw-------  1 postgres postgres 16777216 Feb 26 22:34 000000430000000000000005

-rw-------  1 postgres postgres     2828 Feb 26 22:00 00000043.history

-rw-------  1 postgres postgres 16777216 Feb 26 23:03 000000440000000000000005

-rw-------  1 postgres postgres     2871 Feb 26 22:34 00000044.history

-rw-------  1 postgres postgres 16777216 Feb 27 10:03 000000450000000000000005

-rw-------  1 postgres postgres     2914 Feb 26 23:03 00000045.history

-rw-------  1 postgres postgres 16777216 Feb 27 10:20 000000460000000000000005

-rw-------  1 postgres postgres     2957 Feb 27 10:03 00000046.history

-rw-------  1 postgres postgres 16777216 Feb 27 12:18 000000470000000000000005

-rw-------  1 postgres postgres     3000 Feb 27 10:20 00000047.history

-rw-------  1 postgres postgres 16777216 Feb 27 12:52 000000480000000000000005

-rw-------  1 postgres postgres     3043 Feb 27 12:18 00000048.history

-rw-------  1 postgres postgres 16777216 Feb 27 14:25 000000490000000000000005

-rw-------  1 postgres postgres     3086 Feb 27 12:52 00000049.history

-rw-------  1 postgres postgres 16777216 Feb 27 15:09 0000004A0000000000000005

-rw-------  1 postgres postgres     3129 Feb 27 14:25 0000004A.history

-rw-------  1 postgres postgres 16777216 Feb 27 16:23 0000004B0000000000000005

-rw-------  1 postgres postgres     3172 Feb 27 15:09 0000004B.history

-rw-------  1 postgres postgres 16777216 Feb 27 18:10 0000004C0000000000000005

-rw-------  1 postgres postgres     3215 Feb 27 16:23 0000004C.history

-rw-------  1 postgres postgres 16777216 Feb 27 18:37 0000004D0000000000000005

-rw-------  1 postgres postgres     3258 Feb 27 18:10 0000004D.history

-rw-------  1 postgres postgres 16777216 Feb 27 21:23 0000004E0000000000000005

-rw-------  1 postgres postgres     3301 Feb 27 18:37 0000004E.history

-rw-------  1 postgres postgres 16777216 Feb 27 21:31 0000004F0000000000000005

-rw-------  1 postgres postgres     3344 Feb 27 21:23 0000004F.history

-rw-------  1 postgres postgres 16777216 Feb 28 01:12 000000500000000000000005

-rw-------  1 postgres postgres     3387 Feb 27 21:31 00000050.history

-rw-------  1 postgres postgres 16777216 Feb 28 06:58 000000510000000000000005

-rw-------  1 postgres postgres     3430 Feb 28 01:12 00000051.history

-rw-------  1 postgres postgres 16777216 Feb 28 07:48 000000520000000000000005

-rw-------  1 postgres postgres     3473 Feb 28 06:58 00000052.history

-rw-------  1 postgres postgres 16777216 Feb 28 08:12 000000530000000000000005

-rw-------  1 postgres postgres     3516 Feb 28 07:48 00000053.history

-rw-------  1 postgres postgres 16777216 Feb 28 09:00 000000540000000000000005

-rw-------  1 postgres postgres     3559 Feb 28 08:12 00000054.history

-rw-------  1 postgres postgres 16777216 Feb 28 09:14 000000550000000000000005

-rw-------  1 postgres postgres     3602 Feb 28 09:00 00000055.history

-rw-------  1 postgres postgres 16777216 Feb 28 09:22 000000560000000000000005

-rw-------  1 postgres postgres     3645 Feb 28 09:14 00000056.history

-rw-------  1 postgres postgres 16777216 Feb 28 10:18 000000570000000000000005

-rw-------  1 postgres postgres     3688 Feb 28 09:22 00000057.history

-rw-------  1 postgres postgres 16777216 Feb 28 10:26 000000580000000000000005

-rw-------  1 postgres postgres     3731 Feb 28 10:18 00000058.history

-rw-------  1 postgres postgres 16777216 Feb 28 10:45 000000590000000000000005

-rw-------  1 postgres postgres     3774 Feb 28 10:26 00000059.history

-rw-------  1 postgres postgres 16777216 Feb 28 11:16 0000005A0000000000000005

-rw-------  1 postgres postgres     3817 Feb 28 10:45 0000005A.history

-rw-------  1 postgres postgres 16777216 Feb 28 11:24 0000005B0000000000000005

-rw-------  1 postgres postgres     3860 Feb 28 11:16 0000005B.history

-rw-------  1 postgres postgres 16777216 Feb 28 11:47 0000005C0000000000000005

-rw-------  1 postgres postgres     3903 Feb 28 11:24 0000005C.history

-rw-------  1 postgres postgres 16777216 Feb 28 12:01 0000005D0000000000000005

-rw-------  1 postgres postgres     3946 Feb 28 11:47 0000005D.history

-rw-------  1 postgres postgres 16777216 Feb 28 12:54 0000005E0000000000000005

-rw-------  1 postgres postgres     3989 Feb 28 12:01 0000005E.history

-rw-------  1 postgres postgres 16777216 Feb 28 13:04 0000005F0000000000000005

-rw-------  1 postgres postgres     4032 Feb 28 12:54 0000005F.history

-rw-------  1 postgres postgres 16777216 Feb 28 13:33 000000600000000000000005

-rw-------  1 postgres postgres     4075 Feb 28 13:04 00000060.history

-rw-------  1 postgres postgres 16777216 Feb 28 13:59 000000610000000000000005

-rw-------  1 postgres postgres     4118 Feb 28 13:33 00000061.history

-rw-------  1 postgres postgres 16777216 Feb 28 15:12 000000620000000000000005

-rw-------  1 postgres postgres     4161 Feb 28 13:59 00000062.history

-rw-------  1 postgres postgres 16777216 Feb 28 15:20 000000630000000000000005

-rw-------  1 postgres postgres     4204 Feb 28 15:12 00000063.history

-rw-------  1 postgres postgres 16777216 Feb 28 15:36 000000640000000000000005

-rw-------  1 postgres postgres     4247 Feb 28 15:20 00000064.history

-rw-------  1 postgres postgres 16777216 Feb 28 15:45 000000650000000000000005

-rw-------  1 postgres postgres     4291 Feb 28 15:36 00000065.history

-rw-------  1 postgres postgres 16777216 Feb 28 16:12 000000660000000000000005

-rw-------  1 postgres postgres     4335 Feb 28 15:45 00000066.history

-rw-------  1 postgres postgres 16777216 Feb 29 08:50 000000670000000000000005

-rw-------  1 postgres postgres     4379 Feb 28 16:12 00000067.history

-rw-------  1 postgres postgres 16777216 Mar  2 08:46 000000680000000000000005

-rw-------  1 postgres postgres     4423 Feb 29 08:51 00000068.history

-rw-------  1 postgres postgres 16777216 Mar  2 12:07 000000690000000000000005

-rw-------  1 postgres postgres     4467 Mar  2 08:46 00000069.history

-rw-------  1 postgres postgres 16777216 Mar  2 12:17 0000006A0000000000000005

-rw-------  1 postgres postgres     4511 Mar  2 12:07 0000006A.history

-rw-------  1 postgres postgres 16777216 Mar  2 12:46 0000006B0000000000000005

-rw-------  1 postgres postgres     4555 Mar  2 12:17 0000006B.history

-rw-------  1 postgres postgres 16777216 Mar  2 18:55 0000006C0000000000000005

-rw-------  1 postgres postgres     4599 Mar  2 12:46 0000006C.history

-rw-------  1 postgres postgres 16777216 Mar  2 19:03 0000006D0000000000000005

-rw-------  1 postgres postgres     4643 Mar  2 18:55 0000006D.history

-rw-------  1 postgres postgres 16777216 Mar  2 19:28 0000006E0000000000000005

-rw-------  1 postgres postgres     4687 Mar  2 19:03 0000006E.history

-rw-------  1 postgres postgres 16777216 Mar  2 19:36 0000006F0000000000000005

-rw-------  1 postgres postgres     4731 Mar  2 19:28 0000006F.history

-rw-------  1 postgres postgres 16777216 Mar  2 19:42 000000700000000000000005

-rw-------  1 postgres postgres     4775 Mar  2 19:37 00000070.history

-rw-------  1 postgres postgres 16777216 Mar  2 19:53 000000710000000000000005

-rw-------  1 postgres postgres     4819 Mar  2 19:42 00000071.history

-rw-------  1 postgres postgres 16777216 Mar  2 20:08 000000720000000000000005

-rw-------  1 postgres postgres     4863 Mar  2 19:54 00000072.history

-rw-------  1 postgres postgres 16777216 Mar  2 21:22 000000730000000000000005

-rw-------  1 postgres postgres     4907 Mar  2 20:08 00000073.history

-rw-------  1 postgres postgres 16777216 Mar  2 21:31 000000740000000000000005

-rw-------  1 postgres postgres     4951 Mar  2 21:22 00000074.history

-rw-------  1 postgres postgres 16777216 Mar  2 21:41 000000750000000000000005

-rw-------  1 postgres postgres     4995 Mar  2 21:31 00000075.history

-rw-------  1 postgres postgres 16777216 Mar  2 21:48 000000760000000000000005

-rw-------  1 postgres postgres     5039 Mar  2 21:41 00000076.history

-rw-------  1 postgres postgres 16777216 Mar  2 22:07 000000770000000000000005

-rw-------  1 postgres postgres     5083 Mar  2 21:49 00000077.history

-rw-------  1 postgres postgres 16777216 Mar  2 22:45 000000780000000000000005

-rw-------  1 postgres postgres     5127 Mar  2 22:07 00000078.history

-rw-------  1 postgres postgres 16777216 Mar  2 23:04 000000790000000000000005

-rw-------  1 postgres postgres     5171 Mar  2 22:45 00000079.history

-rw-------  1 postgres postgres 16777216 Mar  2 23:31 0000007A0000000000000005

-rw-------  1 postgres postgres     5215 Mar  2 23:04 0000007A.history

-rw-------  1 postgres postgres 16777216 Mar  3 00:06 0000007B0000000000000005

-rw-------  1 postgres postgres     5259 Mar  2 23:31 0000007B.history

-rw-------  1 postgres postgres 16777216 Mar  3 02:01 0000007C0000000000000005

-rw-------  1 postgres postgres     5303 Mar  3 00:06 0000007C.history

-rw-------  1 postgres postgres 16777216 Mar  3 03:14 0000007D0000000000000005

-rw-------  1 postgres postgres     5347 Mar  3 02:01 0000007D.history

-rw-------  1 postgres postgres 16777216 Mar  3 08:12 0000007E0000000000000005

-rw-------  1 postgres postgres     5391 Mar  3 03:14 0000007E.history

-rw-------  1 postgres postgres 16777216 Mar  3 10:19 0000007F0000000000000005

-rw-------  1 postgres postgres     5435 Mar  3 08:12 0000007F.history

-rw-------  1 postgres postgres 16777216 Mar  3 11:28 000000800000000000000005

-rw-------  1 postgres postgres     5479 Mar  3 10:19 00000080.history

-rw-------  1 postgres postgres 16777216 Mar  3 12:00 000000810000000000000005

-rw-------  1 postgres postgres     5523 Mar  3 11:28 00000081.history

-rw-------  1 postgres postgres 16777216 Mar  3 12:41 000000820000000000000005

-rw-------  1 postgres postgres     5567 Mar  3 12:00 00000082.history

-rw-------  1 postgres postgres 16777216 Mar  3 12:49 000000830000000000000005

-rw-------  1 postgres postgres     5611 Mar  3 12:41 00000083.history

-rw-------  1 postgres postgres 16777216 Mar  3 14:10 000000840000000000000005

-rw-------  1 postgres postgres     5655 Mar  3 12:49 00000084.history

-rw-------  1 postgres postgres 16777216 Mar  3 14:40 000000850000000000000005

-rw-------  1 postgres postgres     5699 Mar  3 14:10 00000085.history

-rw-------  1 postgres postgres 16777216 Mar  3 14:48 000000860000000000000005

-rw-------  1 postgres postgres     5743 Mar  3 14:40 00000086.history

-rw-------  1 postgres postgres 16777216 Mar  3 15:25 000000870000000000000005

-rw-------  1 postgres postgres     5787 Mar  3 14:48 00000087.history

-rw-------  1 postgres postgres 16777216 Mar  3 15:56 000000880000000000000005

-rw-------  1 postgres postgres     5831 Mar  3 15:25 00000088.history

-rw-------  1 postgres postgres 16777216 Mar  3 16:34 000000890000000000000005

-rw-------  1 postgres postgres     5875 Mar  3 15:57 00000089.history

-rw-------  1 postgres postgres 16777216 Mar  3 16:36 0000008A0000000000000005

-rw-------  1 postgres postgres     5919 Mar  3 16:34 0000008A.history

-rw-------  1 postgres postgres 16777216 Mar  3 16:37 0000008B0000000000000005

-rw-------  1 postgres postgres     5963 Mar  3 16:36 0000008B.history

-rw-------  1 postgres postgres 16777216 Mar  3 16:42 0000008C0000000000000005

-rw-------  1 postgres postgres     6007 Mar  3 16:38 0000008C.history

-rw-------  1 postgres postgres 16777216 Mar  3 16:44 0000008D0000000000000005

-rw-------  1 postgres postgres     6051 Mar  3 16:42 0000008D.history

-rw-------  1 postgres postgres 16777216 Mar  3 16:45 0000008E0000000000000005

-rw-------  1 postgres postgres     6095 Mar  3 16:44 0000008E.history

-rw-------  1 postgres postgres 16777216 Mar  3 16:56 0000008F0000000000000005

-rw-------  1 postgres postgres     6139 Mar  3 16:45 0000008F.history

-rw-------  1 postgres postgres 16777216 Mar  3 17:01 000000900000000000000005

-rw-------  1 postgres postgres     6183 Mar  3 16:56 00000090.history

-rw-------  1 postgres postgres 16777216 Mar  3 17:04 000000910000000000000005

-rw-------  1 postgres postgres     6227 Mar  3 17:01 00000091.history

-rw-------  1 postgres postgres 16777216 Mar  3 17:55 000000920000000000000005

-rw-------  1 postgres postgres     6271 Mar  3 17:04 00000092.history

-rw-------  1 postgres postgres 16777216 Mar  3 18:04 000000930000000000000005

-rw-------  1 postgres postgres     6315 Mar  3 17:55 00000093.history

-rw-------  1 postgres postgres 16777216 Mar  3 18:13 000000940000000000000005

-rw-------  1 postgres postgres     6359 Mar  3 18:04 00000094.history

-rw-------  1 postgres postgres 16777216 Mar  3 19:27 000000950000000000000005

-rw-------  1 postgres postgres     6403 Mar  3 18:13 00000095.history

-rw-------  1 postgres postgres 16777216 Mar  3 20:20 000000960000000000000005

-rw-------  1 postgres postgres     6447 Mar  3 19:27 00000096.history

-rw-------  1 postgres postgres 16777216 Mar  3 21:31 000000970000000000000005

-rw-------  1 postgres postgres     6491 Mar  3 20:20 00000097.history

-rw-------  1 postgres postgres 16777216 Mar  3 22:38 000000980000000000000005

-rw-------  1 postgres postgres     6535 Mar  3 21:31 00000098.history

-rw-------  1 postgres postgres 16777216 Mar  4 07:25 000000990000000000000005

-rw-------  1 postgres postgres     6579 Mar  3 22:38 00000099.history

-rw-------  1 postgres postgres 16777216 Mar  4 08:06 0000009A0000000000000005

-rw-------  1 postgres postgres     6623 Mar  4 07:25 0000009A.history

-rw-------  1 postgres postgres 16777216 Mar  4 11:09 0000009B0000000000000005

-rw-------  1 postgres postgres     6667 Mar  4 08:06 0000009B.history

-rw-------  1 postgres postgres 16777216 Mar  4 11:38 0000009C0000000000000005

-rw-------  1 postgres postgres     6711 Mar  4 11:09 0000009C.history

-rw-------  1 postgres postgres 16777216 Mar  4 11:54 0000009D0000000000000005

-rw-------  1 postgres postgres     6755 Mar  4 11:38 0000009D.history

-rw-------  1 postgres postgres 16777216 Mar  4 13:57 0000009E0000000000000005

-rw-------  1 postgres postgres     6799 Mar  4 11:54 0000009E.history

-rw-------  1 postgres postgres 16777216 Mar  4 14:19 0000009F0000000000000005

-rw-------  1 postgres postgres     6843 Mar  4 13:57 0000009F.history

-rw-------  1 postgres postgres 16777216 Mar  4 14:25 000000A00000000000000005

-rw-------  1 postgres postgres     6887 Mar  4 14:19 000000A0.history

-rw-------  1 postgres postgres 16777216 Mar  4 14:27 000000A10000000000000005

-rw-------  1 postgres postgres     6931 Mar  4 14:25 000000A1.history

-rw-------  1 postgres postgres 16777216 Mar  4 14:56 000000A20000000000000005

-rw-------  1 postgres postgres     6975 Mar  4 14:27 000000A2.history

-rw-------  1 postgres postgres 16777216 Mar  4 15:47 000000A30000000000000005

-rw-------  1 postgres postgres     7019 Mar  4 14:56 000000A3.history

-rw-------  1 postgres postgres 16777216 Mar  4 15:48 000000A40000000000000005

-rw-------  1 postgres postgres     7063 Mar  4 15:47 000000A4.history

-rw-------  1 postgres postgres 16777216 Mar  4 16:24 000000A50000000000000005

-rw-------  1 postgres postgres     7107 Mar  4 15:48 000000A5.history

-rw-------  1 postgres postgres 16777216 Mar  4 16:31 000000A60000000000000005

-rw-------  1 postgres postgres     7151 Mar  4 16:24 000000A6.history

-rw-------  1 postgres postgres 16777216 Mar  4 16:33 000000A70000000000000005

-rw-------  1 postgres postgres     7195 Mar  4 16:31 000000A7.history

-rw-------  1 postgres postgres 16777216 Mar  4 16:40 000000A80000000000000005

-rw-------  1 postgres postgres     7239 Mar  4 16:33 000000A8.history

-rw-------  1 postgres postgres 16777216 Mar  4 17:00 000000A90000000000000005

-rw-------  1 postgres postgres     7283 Mar  4 16:40 000000A9.history

-rw-------  1 postgres postgres 16777216 Mar  4 17:20 000000AA0000000000000005

-rw-------  1 postgres postgres     7327 Mar  4 17:00 000000AA.history

-rw-------  1 postgres postgres 16777216 Mar  4 17:47 000000AB0000000000000005

-rw-------  1 postgres postgres     7371 Mar  4 17:20 000000AB.history

-rw-------  1 postgres postgres 16777216 Mar  4 17:49 000000AC0000000000000005

-rw-------  1 postgres postgres     7415 Mar  4 17:47 000000AC.history

-rw-------  1 postgres postgres 16777216 Mar  4 17:55 000000AD0000000000000005

-rw-------  1 postgres postgres     7459 Mar  4 17:49 000000AD.history

-rw-------  1 postgres postgres 16777216 Mar  4 17:56 000000AE0000000000000005

-rw-------  1 postgres postgres     7503 Mar  4 17:55 000000AE.history

-rw-------  1 postgres postgres 16777216 Mar  4 17:59 000000AF0000000000000005

-rw-------  1 postgres postgres     7547 Mar  4 17:56 000000AF.history

-rw-------  1 postgres postgres 16777216 Mar  4 18:01 000000B00000000000000005

-rw-------  1 postgres postgres     7591 Mar  4 17:59 000000B0.history

-rw-------  1 postgres postgres 16777216 Mar  4 18:12 000000B10000000000000005

-rw-------  1 postgres postgres     7635 Mar  4 18:01 000000B1.history

-rw-------  1 postgres postgres 16777216 Mar  4 18:38 000000B20000000000000005

-rw-------  1 postgres postgres     7679 Mar  4 18:12 000000B2.history

-rw-------  1 postgres postgres 16777216 Mar  4 18:47 000000B30000000000000005

-rw-------  1 postgres postgres     7723 Mar  4 18:38 000000B3.history

-rw-------  1 postgres postgres 16777216 Mar  4 18:52 000000B40000000000000005

-rw-------  1 postgres postgres     7767 Mar  4 18:48 000000B4.history

-rw-------  1 postgres postgres 16777216 Mar  4 18:58 000000B50000000000000005

-rw-------  1 postgres postgres     7811 Mar  4 18:53 000000B5.history

-rw-------  1 postgres postgres 16777216 Mar  4 19:02 000000B60000000000000005

-rw-------  1 postgres postgres     7855 Mar  4 18:59 000000B6.history

-rw-------  1 postgres postgres 16777216 Mar  4 19:16 000000B70000000000000005

-rw-------  1 postgres postgres     7899 Mar  4 19:02 000000B7.history

-rw-------  1 postgres postgres 16777216 Mar  4 19:26 000000B80000000000000005

-rw-------  1 postgres postgres     7943 Mar  4 19:16 000000B8.history

-rw-------  1 postgres postgres 16777216 Mar  4 20:06 000000B90000000000000005

-rw-------  1 postgres postgres     7987 Mar  4 19:26 000000B9.history

-rw-------  1 postgres postgres 16777216 Mar  4 20:26 000000BA0000000000000005

-rw-------  1 postgres postgres     8031 Mar  4 20:06 000000BA.history

-rw-------  1 postgres postgres 16777216 Mar  5 15:06 000000BB0000000000000005

-rw-------  1 postgres postgres     8075 Mar  4 20:26 000000BB.history

-rw-------  1 postgres postgres 16777216 Mar  5 15:36 000000BC0000000000000005

-rw-------  1 postgres postgres     8119 Mar  5 15:06 000000BC.history

-rw-------  1 postgres postgres 16777216 Mar  5 16:25 000000BD0000000000000005

-rw-------  1 postgres postgres     8163 Mar  5 15:36 000000BD.history

-rw-------  1 postgres postgres 16777216 Mar  5 16:57 000000BE0000000000000005

-rw-------  1 postgres postgres     8207 Mar  5 16:25 000000BE.history

-rw-------  1 postgres postgres 16777216 Mar  5 17:25 000000BF0000000000000005

-rw-------  1 postgres postgres     8251 Mar  5 16:57 000000BF.history

-rw-------  1 postgres postgres 16777216 Mar  5 19:14 000000C00000000000000005

-rw-------  1 postgres postgres     8295 Mar  5 17:25 000000C0.history

-rw-------  1 postgres postgres 16777216 Mar  5 19:41 000000C10000000000000005

-rw-------  1 postgres postgres     8339 Mar  5 19:14 000000C1.history

-rw-------  1 postgres postgres 16777216 Mar  7 09:42 000000C20000000000000005

-rw-------  1 postgres postgres     8383 Mar  5 19:41 000000C2.history

-rw-------  1 postgres postgres 16777216 Mar 11 13:44 000000C30000000000000005

-rw-------  1 postgres postgres     8427 Mar  7 09:42 000000C3.history

-rw-------  1 postgres postgres 16777216 Mar 11 18:54 000000C40000000000000005

-rw-------  1 postgres postgres     8471 Mar 11 13:44 000000C4.history

-rw-------  1 postgres postgres 16777216 Mar 11 18:55 000000C50000000000000005

-rw-------  1 postgres postgres     8515 Mar 11 18:55 000000C5.history

-rw-------  1 postgres postgres 16777216 Mar 22 19:26 000000C60000000000000005

-rw-------  1 postgres postgres     8559 Mar 20 08:10 000000C6.history

-rw-------  1 postgres postgres 16777216 Mar 22 19:29 000000C70000000000000005

-rw-------  1 postgres postgres     8603 Mar 22 19:26 000000C7.history

-rw-------  1 postgres postgres 16777216 Mar 22 23:29 000000C80000000000000005

-rw-------  1 postgres postgres     8647 Mar 22 19:29 000000C8.history

-rw-------  1 postgres postgres 16777216 Mar 22 23:41 000000C90000000000000005

-rw-------  1 postgres postgres     8691 Mar 22 23:29 000000C9.history

-rw-------  1 postgres postgres 16777216 Mar 23 00:46 000000CA0000000000000005

-rw-------  1 postgres postgres     8735 Mar 22 23:41 000000CA.history

-rw-------  1 postgres postgres 16777216 Mar 23 02:14 000000CB0000000000000005

-rw-------  1 postgres postgres     8779 Mar 23 00:46 000000CB.history

-rw-------  1 postgres postgres 16777216 Mar 23 02:52 000000CC0000000000000005

-rw-------  1 postgres postgres     8823 Mar 23 02:14 000000CC.history

-rw-------  1 postgres postgres 16777216 Mar 23 10:24 000000CD0000000000000005

-rw-------  1 postgres postgres     8867 Mar 23 02:52 000000CD.history

-rw-------  1 postgres postgres 16777216 Mar 23 11:15 000000CE0000000000000005

-rw-------  1 postgres postgres     8911 Mar 23 10:24 000000CE.history

-rw-------  1 postgres postgres 16777216 Mar 23 13:06 000000CF0000000000000005

-rw-------  1 postgres postgres     8955 Mar 23 11:15 000000CF.history

-rw-------  1 postgres postgres 16777216 Mar 23 13:16 000000D00000000000000005

-rw-------  1 postgres postgres     8999 Mar 23 13:06 000000D0.history

-rw-------  1 postgres postgres 16777216 Mar 23 15:23 000000D10000000000000005

-rw-------  1 postgres postgres     9043 Mar 23 13:16 000000D1.history

-rw-------  1 postgres postgres 16777216 Mar 23 21:33 000000D20000000000000005

-rw-------  1 postgres postgres     9087 Mar 23 15:23 000000D2.history

-rw-------  1 postgres postgres 16777216 Mar 23 21:43 000000D30000000000000005

-rw-------  1 postgres postgres     9131 Mar 23 21:33 000000D3.history

-rw-------  1 postgres postgres 16777216 Mar 24 03:06 000000D40000000000000005

-rw-------  1 postgres postgres     9175 Mar 23 21:43 000000D4.history

-rw-------  1 postgres postgres 16777216 Mar 24 03:16 000000D50000000000000005

-rw-------  1 postgres postgres     9219 Mar 24 03:06 000000D5.history

-rw-------  1 postgres postgres 16777216 Mar 24 04:25 000000D60000000000000005

-rw-------  1 postgres postgres     9263 Mar 24 03:16 000000D6.history

-rw-------  1 postgres postgres 16777216 Mar 24 04:34 000000D70000000000000005

-rw-------  1 postgres postgres     9307 Mar 24 04:25 000000D7.history

-rw-------  1 postgres postgres 16777216 Mar 24 08:24 000000D80000000000000005

-rw-------  1 postgres postgres     9351 Mar 24 04:34 000000D8.history

-rw-------  1 postgres postgres 16777216 Mar 24 08:59 000000D90000000000000005

-rw-------  1 postgres postgres     9395 Mar 24 08:24 000000D9.history

-rw-------  1 postgres postgres 16777216 Mar 24 09:09 000000DA0000000000000005

-rw-------  1 postgres postgres     9439 Mar 24 08:59 000000DA.history

-rw-------  1 postgres postgres 16777216 Mar 24 11:06 000000DB0000000000000005

-rw-------  1 postgres postgres     9483 Mar 24 09:09 000000DB.history

-rw-------  1 postgres postgres 16777216 Mar 24 11:14 000000DC0000000000000005

-rw-------  1 postgres postgres     9527 Mar 24 11:06 000000DC.history

-rw-------  1 postgres postgres 16777216 Mar 24 15:33 000000DD0000000000000005

-rw-------  1 postgres postgres     9571 Mar 24 11:14 000000DD.history

-rw-------  1 postgres postgres 16777216 Mar 24 16:33 000000DE0000000000000005

-rw-------  1 postgres postgres     9615 Mar 24 15:33 000000DE.history

-rw-------  1 postgres postgres 16777216 Mar 24 19:37 000000DF0000000000000005

-rw-------  1 postgres postgres     9659 Mar 24 16:33 000000DF.history

-rw-------  1 postgres postgres 16777216 Mar 24 19:54 000000E00000000000000005

-rw-------  1 postgres postgres     9703 Mar 24 19:37 000000E0.history

-rw-------  1 postgres postgres 16777216 Mar 24 22:02 000000E10000000000000005

-rw-------  1 postgres postgres     9747 Mar 24 19:54 000000E1.history

-rw-------  1 postgres postgres 16777216 Mar 25 06:31 000000E20000000000000005

-rw-------  1 postgres postgres     9791 Mar 24 22:02 000000E2.history

-rw-------  1 postgres postgres 16777216 Mar 25 07:08 000000E30000000000000005

-rw-------  1 postgres postgres     9835 Mar 25 06:31 000000E3.history

-rw-------  1 postgres postgres 16777216 Mar 25 08:44 000000E40000000000000005

-rw-------  1 postgres postgres     9879 Mar 25 07:08 000000E4.history

-rw-------  1 postgres postgres 16777216 Mar 25 09:13 000000E50000000000000005

-rw-------  1 postgres postgres     9923 Mar 25 08:44 000000E5.history

-rw-------  1 postgres postgres 16777216 Mar 25 09:29 000000E60000000000000005

-rw-------  1 postgres postgres     9967 Mar 25 09:13 000000E6.history

-rw-------  1 postgres postgres 16777216 Mar 25 09:54 000000E70000000000000005

-rw-------  1 postgres postgres    10011 Mar 25 09:29 000000E7.history

-rw-------  1 postgres postgres 16777216 Mar 25 10:37 000000E80000000000000005

-rw-------  1 postgres postgres    10055 Mar 25 09:54 000000E8.history

-rw-------  1 postgres postgres 16777216 Mar 25 13:43 000000E90000000000000005

-rw-------  1 postgres postgres    10099 Mar 25 10:37 000000E9.history

-rw-------  1 postgres postgres 16777216 Mar 25 13:52 000000EA0000000000000005

-rw-------  1 postgres postgres    10143 Mar 25 13:43 000000EA.history

-rw-------  1 postgres postgres 16777216 Mar 25 14:15 000000EB0000000000000005

-rw-------  1 postgres postgres    10187 Mar 25 13:52 000000EB.history

-rw-------  1 postgres postgres 16777216 Mar 25 14:29 000000EC0000000000000005

-rw-------  1 postgres postgres    10231 Mar 25 14:15 000000EC.history

-rw-------  1 postgres postgres 16777216 Mar 25 15:03 000000ED0000000000000005

-rw-------  1 postgres postgres    10275 Mar 25 14:29 000000ED.history

-rw-------  1 postgres postgres 16777216 Mar 25 16:42 000000EE0000000000000005

-rw-------  1 postgres postgres    10319 Mar 25 15:03 000000EE.history

-rw-------  1 postgres postgres 16777216 Mar 25 18:34 000000EF0000000000000005

-rw-------  1 postgres postgres    10363 Mar 25 16:42 000000EF.history

-rw-------  1 postgres postgres 16777216 Mar 25 19:23 000000F00000000000000005

-rw-------  1 postgres postgres    10407 Mar 25 18:34 000000F0.history

-rw-------  1 postgres postgres 16777216 Mar 25 22:20 000000F10000000000000005

-rw-------  1 postgres postgres    10451 Mar 25 19:23 000000F1.history

drwx------  2 postgres postgres    12288 Mar 25 19:23 archive_status

 

ss7-db-pg-0:/ # psql -U postgres

psql (10.10)

Type "help" for help.

 

postgres=# ps uwwxf | grep -C3 archive

postgres-#

 

BRs

Fan Liu

RE: BUG #16317: max_wal_size does not remove WAL files, cause "nospace left"

От
Fan Liu
Дата:

Hi,

 

I have to clean up some space today, so I removed some WAL from Feb.

But the issue is still there, WAL keep increasing.

 

 

-------------- LOG -----------------------------------------------------------------------------------

postgres=# select pg_walfile_name( pg_current_wal_lsn());

DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0

DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0

     pg_walfile_name

--------------------------

000000F30000000000000009

(1 row)

 

postgres=#

 

 

db-pg-0:/var/lib/postgresql/data/pgdata # ls -alh pg_wal/

total 2.3G

drwx------  3 postgres postgres  20K Mar 26 10:56 .

drwx------ 19 postgres postgres 4.0K Mar 26 09:32 ..

-rw-------  1 postgres postgres  16M Mar  2 08:46 000000680000000000000005

-rw-------  1 postgres postgres  16M Mar  2 12:07 000000690000000000000005

-rw-------  1 postgres postgres 4.4K Mar  2 08:46 00000069.history

-rw-------  1 postgres postgres  16M Mar  2 12:17 0000006A0000000000000005

-rw-------  1 postgres postgres 4.5K Mar  2 12:07 0000006A.history

-rw-------  1 postgres postgres  16M Mar  2 12:46 0000006B0000000000000005

-rw-------  1 postgres postgres 4.5K Mar  2 12:17 0000006B.history

-rw-------  1 postgres postgres  16M Mar  2 18:55 0000006C0000000000000005

-rw-------  1 postgres postgres 4.5K Mar  2 12:46 0000006C.history

-rw-------  1 postgres postgres  16M Mar  2 19:03 0000006D0000000000000005

-rw-------  1 postgres postgres 4.6K Mar  2 18:55 0000006D.history

-rw-------  1 postgres postgres  16M Mar  2 19:28 0000006E0000000000000005

-rw-------  1 postgres postgres 4.6K Mar  2 19:03 0000006E.history

-rw-------  1 postgres postgres  16M Mar  2 19:36 0000006F0000000000000005

-rw-------  1 postgres postgres 4.7K Mar  2 19:28 0000006F.history

-rw-------  1 postgres postgres  16M Mar  2 19:42 000000700000000000000005

-rw-------  1 postgres postgres 4.7K Mar  2 19:37 00000070.history

-rw-------  1 postgres postgres  16M Mar  2 19:53 000000710000000000000005

-rw-------  1 postgres postgres 4.8K Mar  2 19:42 00000071.history

-rw-------  1 postgres postgres  16M Mar  2 20:08 000000720000000000000005

-rw-------  1 postgres postgres 4.8K Mar  2 19:54 00000072.history

-rw-------  1 postgres postgres  16M Mar  2 21:22 000000730000000000000005

-rw-------  1 postgres postgres 4.8K Mar  2 20:08 00000073.history

-rw-------  1 postgres postgres  16M Mar  2 21:31 000000740000000000000005

-rw-------  1 postgres postgres 4.9K Mar  2 21:22 00000074.history

-rw-------  1 postgres postgres  16M Mar  2 21:41 000000750000000000000005

-rw-------  1 postgres postgres 4.9K Mar  2 21:31 00000075.history

-rw-------  1 postgres postgres  16M Mar  2 21:48 000000760000000000000005

-rw-------  1 postgres postgres 5.0K Mar  2 21:41 00000076.history

-rw-------  1 postgres postgres  16M Mar  2 22:07 000000770000000000000005

-rw-------  1 postgres postgres 5.0K Mar  2 21:49 00000077.history

-rw-------  1 postgres postgres  16M Mar  2 22:45 000000780000000000000005

-rw-------  1 postgres postgres 5.1K Mar  2 22:07 00000078.history

-rw-------  1 postgres postgres  16M Mar  2 23:04 000000790000000000000005

-rw-------  1 postgres postgres 5.1K Mar  2 22:45 00000079.history

-rw-------  1 postgres postgres  16M Mar  2 23:31 0000007A0000000000000005

-rw-------  1 postgres postgres 5.1K Mar  2 23:04 0000007A.history

-rw-------  1 postgres postgres  16M Mar  3 00:06 0000007B0000000000000005

-rw-------  1 postgres postgres 5.2K Mar  2 23:31 0000007B.history

-rw-------  1 postgres postgres  16M Mar  3 02:01 0000007C0000000000000005

-rw-------  1 postgres postgres 5.2K Mar  3 00:06 0000007C.history

-rw-------  1 postgres postgres  16M Mar  3 03:14 0000007D0000000000000005

-rw-------  1 postgres postgres 5.3K Mar  3 02:01 0000007D.history

-rw-------  1 postgres postgres  16M Mar  3 08:12 0000007E0000000000000005

-rw-------  1 postgres postgres 5.3K Mar  3 03:14 0000007E.history

-rw-------  1 postgres postgres  16M Mar  3 10:19 0000007F0000000000000005

-rw-------  1 postgres postgres 5.4K Mar  3 08:12 0000007F.history

-rw-------  1 postgres postgres  16M Mar  3 11:28 000000800000000000000005

-rw-------  1 postgres postgres 5.4K Mar  3 10:19 00000080.history

-rw-------  1 postgres postgres  16M Mar  3 12:00 000000810000000000000005

-rw-------  1 postgres postgres 5.4K Mar  3 11:28 00000081.history

-rw-------  1 postgres postgres  16M Mar  3 12:41 000000820000000000000005

-rw-------  1 postgres postgres 5.5K Mar  3 12:00 00000082.history

-rw-------  1 postgres postgres  16M Mar  3 12:49 000000830000000000000005

-rw-------  1 postgres postgres 5.5K Mar  3 12:41 00000083.history

-rw-------  1 postgres postgres  16M Mar  3 14:10 000000840000000000000005

-rw-------  1 postgres postgres 5.6K Mar  3 12:49 00000084.history

-rw-------  1 postgres postgres  16M Mar  3 14:40 000000850000000000000005

-rw-------  1 postgres postgres 5.6K Mar  3 14:10 00000085.history

-rw-------  1 postgres postgres  16M Mar  3 14:48 000000860000000000000005

-rw-------  1 postgres postgres 5.7K Mar  3 14:40 00000086.history

-rw-------  1 postgres postgres  16M Mar  3 15:25 000000870000000000000005

-rw-------  1 postgres postgres 5.7K Mar  3 14:48 00000087.history

-rw-------  1 postgres postgres  16M Mar  3 15:56 000000880000000000000005

-rw-------  1 postgres postgres 5.7K Mar  3 15:25 00000088.history

-rw-------  1 postgres postgres  16M Mar  3 16:34 000000890000000000000005

-rw-------  1 postgres postgres 5.8K Mar  3 15:57 00000089.history

-rw-------  1 postgres postgres  16M Mar  3 16:36 0000008A0000000000000005

-rw-------  1 postgres postgres 5.8K Mar  3 16:34 0000008A.history

-rw-------  1 postgres postgres  16M Mar  3 16:37 0000008B0000000000000005

-rw-------  1 postgres postgres 5.9K Mar  3 16:36 0000008B.history

-rw-------  1 postgres postgres  16M Mar  3 16:42 0000008C0000000000000005

-rw-------  1 postgres postgres 5.9K Mar  3 16:38 0000008C.history

-rw-------  1 postgres postgres  16M Mar  3 16:44 0000008D0000000000000005

-rw-------  1 postgres postgres 6.0K Mar  3 16:42 0000008D.history

-rw-------  1 postgres postgres  16M Mar  3 16:45 0000008E0000000000000005

-rw-------  1 postgres postgres 6.0K Mar  3 16:44 0000008E.history

-rw-------  1 postgres postgres  16M Mar  3 16:56 0000008F0000000000000005

-rw-------  1 postgres postgres 6.0K Mar  3 16:45 0000008F.history

-rw-------  1 postgres postgres  16M Mar  3 17:01 000000900000000000000005

-rw-------  1 postgres postgres 6.1K Mar  3 16:56 00000090.history

-rw-------  1 postgres postgres  16M Mar  3 17:04 000000910000000000000005

-rw-------  1 postgres postgres 6.1K Mar  3 17:01 00000091.history

-rw-------  1 postgres postgres  16M Mar  3 17:55 000000920000000000000005

-rw-------  1 postgres postgres 6.2K Mar  3 17:04 00000092.history

-rw-------  1 postgres postgres  16M Mar  3 18:04 000000930000000000000005

-rw-------  1 postgres postgres 6.2K Mar  3 17:55 00000093.history

-rw-------  1 postgres postgres  16M Mar  3 18:13 000000940000000000000005

-rw-------  1 postgres postgres 6.3K Mar  3 18:04 00000094.history

-rw-------  1 postgres postgres  16M Mar  3 19:27 000000950000000000000005

-rw-------  1 postgres postgres 6.3K Mar  3 18:13 00000095.history

-rw-------  1 postgres postgres  16M Mar  3 20:20 000000960000000000000005

-rw-------  1 postgres postgres 6.3K Mar  3 19:27 00000096.history

-rw-------  1 postgres postgres  16M Mar  3 21:31 000000970000000000000005

-rw-------  1 postgres postgres 6.4K Mar  3 20:20 00000097.history

-rw-------  1 postgres postgres  16M Mar  3 22:38 000000980000000000000005

-rw-------  1 postgres postgres 6.4K Mar  3 21:31 00000098.history

-rw-------  1 postgres postgres  16M Mar  4 07:25 000000990000000000000005

-rw-------  1 postgres postgres 6.5K Mar  3 22:38 00000099.history

-rw-------  1 postgres postgres  16M Mar  4 08:06 0000009A0000000000000005

-rw-------  1 postgres postgres 6.5K Mar  4 07:25 0000009A.history

-rw-------  1 postgres postgres  16M Mar  4 11:09 0000009B0000000000000005

-rw-------  1 postgres postgres 6.6K Mar  4 08:06 0000009B.history

-rw-------  1 postgres postgres  16M Mar  4 11:38 0000009C0000000000000005

-rw-------  1 postgres postgres 6.6K Mar  4 11:09 0000009C.history

-rw-------  1 postgres postgres  16M Mar  4 11:54 0000009D0000000000000005

-rw-------  1 postgres postgres 6.6K Mar  4 11:38 0000009D.history

-rw-------  1 postgres postgres  16M Mar  4 13:57 0000009E0000000000000005

-rw-------  1 postgres postgres 6.7K Mar  4 11:54 0000009E.history

-rw-------  1 postgres postgres  16M Mar  4 14:19 0000009F0000000000000005

-rw-------  1 postgres postgres 6.7K Mar  4 13:57 0000009F.history

-rw-------  1 postgres postgres  16M Mar  4 14:25 000000A00000000000000005

-rw-------  1 postgres postgres 6.8K Mar  4 14:19 000000A0.history

-rw-------  1 postgres postgres  16M Mar  4 14:27 000000A10000000000000005

-rw-------  1 postgres postgres 6.8K Mar  4 14:25 000000A1.history

-rw-------  1 postgres postgres  16M Mar  4 14:56 000000A20000000000000005

-rw-------  1 postgres postgres 6.9K Mar  4 14:27 000000A2.history

-rw-------  1 postgres postgres  16M Mar  4 15:47 000000A30000000000000005

-rw-------  1 postgres postgres 6.9K Mar  4 14:56 000000A3.history

-rw-------  1 postgres postgres  16M Mar  4 15:48 000000A40000000000000005

-rw-------  1 postgres postgres 6.9K Mar  4 15:47 000000A4.history

-rw-------  1 postgres postgres  16M Mar  4 16:24 000000A50000000000000005

-rw-------  1 postgres postgres 7.0K Mar  4 15:48 000000A5.history

-rw-------  1 postgres postgres  16M Mar  4 16:31 000000A60000000000000005

-rw-------  1 postgres postgres 7.0K Mar  4 16:24 000000A6.history

-rw-------  1 postgres postgres  16M Mar  4 16:33 000000A70000000000000005

-rw-------  1 postgres postgres 7.1K Mar  4 16:31 000000A7.history

-rw-------  1 postgres postgres  16M Mar  4 16:40 000000A80000000000000005

-rw-------  1 postgres postgres 7.1K Mar  4 16:33 000000A8.history

-rw-------  1 postgres postgres  16M Mar  4 17:00 000000A90000000000000005

-rw-------  1 postgres postgres 7.2K Mar  4 16:40 000000A9.history

-rw-------  1 postgres postgres  16M Mar  4 17:20 000000AA0000000000000005

-rw-------  1 postgres postgres 7.2K Mar  4 17:00 000000AA.history

-rw-------  1 postgres postgres  16M Mar  4 17:47 000000AB0000000000000005

-rw-------  1 postgres postgres 7.2K Mar  4 17:20 000000AB.history

-rw-------  1 postgres postgres  16M Mar  4 17:49 000000AC0000000000000005

-rw-------  1 postgres postgres 7.3K Mar  4 17:47 000000AC.history

-rw-------  1 postgres postgres  16M Mar  4 17:55 000000AD0000000000000005

-rw-------  1 postgres postgres 7.3K Mar  4 17:49 000000AD.history

-rw-------  1 postgres postgres  16M Mar  4 17:56 000000AE0000000000000005

-rw-------  1 postgres postgres 7.4K Mar  4 17:55 000000AE.history

-rw-------  1 postgres postgres  16M Mar  4 17:59 000000AF0000000000000005

-rw-------  1 postgres postgres 7.4K Mar  4 17:56 000000AF.history

-rw-------  1 postgres postgres  16M Mar  4 18:01 000000B00000000000000005

-rw-------  1 postgres postgres 7.5K Mar  4 17:59 000000B0.history

-rw-------  1 postgres postgres  16M Mar  4 18:12 000000B10000000000000005

-rw-------  1 postgres postgres 7.5K Mar  4 18:01 000000B1.history

-rw-------  1 postgres postgres  16M Mar  4 18:38 000000B20000000000000005

-rw-------  1 postgres postgres 7.5K Mar  4 18:12 000000B2.history

-rw-------  1 postgres postgres  16M Mar  4 18:47 000000B30000000000000005

-rw-------  1 postgres postgres 7.6K Mar  4 18:38 000000B3.history

-rw-------  1 postgres postgres  16M Mar  4 18:52 000000B40000000000000005

-rw-------  1 postgres postgres 7.6K Mar  4 18:48 000000B4.history

-rw-------  1 postgres postgres  16M Mar  4 18:58 000000B50000000000000005

-rw-------  1 postgres postgres 7.7K Mar  4 18:53 000000B5.history

-rw-------  1 postgres postgres  16M Mar  4 19:02 000000B60000000000000005

-rw-------  1 postgres postgres 7.7K Mar  4 18:59 000000B6.history

-rw-------  1 postgres postgres  16M Mar  4 19:16 000000B70000000000000005

-rw-------  1 postgres postgres 7.8K Mar  4 19:02 000000B7.history

-rw-------  1 postgres postgres  16M Mar  4 19:26 000000B80000000000000005

-rw-------  1 postgres postgres 7.8K Mar  4 19:16 000000B8.history

-rw-------  1 postgres postgres  16M Mar  4 20:06 000000B90000000000000005

-rw-------  1 postgres postgres 7.8K Mar  4 19:26 000000B9.history

-rw-------  1 postgres postgres  16M Mar  4 20:26 000000BA0000000000000005

-rw-------  1 postgres postgres 7.9K Mar  4 20:06 000000BA.history

-rw-------  1 postgres postgres  16M Mar  5 15:06 000000BB0000000000000005

-rw-------  1 postgres postgres 7.9K Mar  4 20:26 000000BB.history

-rw-------  1 postgres postgres  16M Mar  5 15:36 000000BC0000000000000005

-rw-------  1 postgres postgres 8.0K Mar  5 15:06 000000BC.history

-rw-------  1 postgres postgres  16M Mar  5 16:25 000000BD0000000000000005

-rw-------  1 postgres postgres 8.0K Mar  5 15:36 000000BD.history

-rw-------  1 postgres postgres  16M Mar  5 16:57 000000BE0000000000000005

-rw-------  1 postgres postgres 8.1K Mar  5 16:25 000000BE.history

-rw-------  1 postgres postgres  16M Mar  5 17:25 000000BF0000000000000005

-rw-------  1 postgres postgres 8.1K Mar  5 16:57 000000BF.history

-rw-------  1 postgres postgres  16M Mar  5 19:14 000000C00000000000000005

-rw-------  1 postgres postgres 8.2K Mar  5 17:25 000000C0.history

-rw-------  1 postgres postgres  16M Mar  5 19:41 000000C10000000000000005

-rw-------  1 postgres postgres 8.2K Mar  5 19:14 000000C1.history

-rw-------  1 postgres postgres  16M Mar  7 09:42 000000C20000000000000005

-rw-------  1 postgres postgres 8.2K Mar  5 19:41 000000C2.history

-rw-------  1 postgres postgres  16M Mar 11 13:44 000000C30000000000000005

-rw-------  1 postgres postgres 8.3K Mar  7 09:42 000000C3.history

-rw-------  1 postgres postgres  16M Mar 11 18:54 000000C40000000000000005

-rw-------  1 postgres postgres 8.3K Mar 11 13:44 000000C4.history

-rw-------  1 postgres postgres  16M Mar 11 18:55 000000C50000000000000005

-rw-------  1 postgres postgres 8.4K Mar 11 18:55 000000C5.history

-rw-------  1 postgres postgres  16M Mar 22 19:26 000000C60000000000000005

-rw-------  1 postgres postgres 8.4K Mar 20 08:10 000000C6.history

-rw-------  1 postgres postgres  16M Mar 22 19:29 000000C70000000000000005

-rw-------  1 postgres postgres 8.5K Mar 22 19:26 000000C7.history

-rw-------  1 postgres postgres  16M Mar 22 23:29 000000C80000000000000005

-rw-------  1 postgres postgres 8.5K Mar 22 19:29 000000C8.history

-rw-------  1 postgres postgres  16M Mar 22 23:41 000000C90000000000000005

-rw-------  1 postgres postgres 8.5K Mar 22 23:29 000000C9.history

-rw-------  1 postgres postgres  16M Mar 23 00:46 000000CA0000000000000005

-rw-------  1 postgres postgres 8.6K Mar 22 23:41 000000CA.history

-rw-------  1 postgres postgres  16M Mar 23 02:14 000000CB0000000000000005

-rw-------  1 postgres postgres 8.6K Mar 23 00:46 000000CB.history

-rw-------  1 postgres postgres  16M Mar 23 02:52 000000CC0000000000000005

-rw-------  1 postgres postgres 8.7K Mar 23 02:14 000000CC.history

-rw-------  1 postgres postgres  16M Mar 23 10:24 000000CD0000000000000005

-rw-------  1 postgres postgres 8.7K Mar 23 02:52 000000CD.history

-rw-------  1 postgres postgres  16M Mar 23 11:15 000000CE0000000000000005

-rw-------  1 postgres postgres 8.8K Mar 23 10:24 000000CE.history

-rw-------  1 postgres postgres  16M Mar 23 13:06 000000CF0000000000000005

-rw-------  1 postgres postgres 8.8K Mar 23 11:15 000000CF.history

-rw-------  1 postgres postgres  16M Mar 23 13:16 000000D00000000000000005

-rw-------  1 postgres postgres 8.8K Mar 23 13:06 000000D0.history

-rw-------  1 postgres postgres  16M Mar 23 15:23 000000D10000000000000005

-rw-------  1 postgres postgres 8.9K Mar 23 13:16 000000D1.history

-rw-------  1 postgres postgres  16M Mar 23 21:33 000000D20000000000000005

-rw-------  1 postgres postgres 8.9K Mar 23 15:23 000000D2.history

-rw-------  1 postgres postgres  16M Mar 23 21:43 000000D30000000000000005

-rw-------  1 postgres postgres 9.0K Mar 23 21:33 000000D3.history

-rw-------  1 postgres postgres  16M Mar 24 03:06 000000D40000000000000005

-rw-------  1 postgres postgres 9.0K Mar 23 21:43 000000D4.history

-rw-------  1 postgres postgres  16M Mar 24 03:16 000000D50000000000000005

-rw-------  1 postgres postgres 9.1K Mar 24 03:06 000000D5.history

-rw-------  1 postgres postgres  16M Mar 24 04:25 000000D60000000000000005

-rw-------  1 postgres postgres 9.1K Mar 24 03:16 000000D6.history

-rw-------  1 postgres postgres  16M Mar 24 04:34 000000D70000000000000005

-rw-------  1 postgres postgres 9.1K Mar 24 04:25 000000D7.history

-rw-------  1 postgres postgres  16M Mar 24 08:24 000000D80000000000000005

-rw-------  1 postgres postgres 9.2K Mar 24 04:34 000000D8.history

-rw-------  1 postgres postgres  16M Mar 24 08:59 000000D90000000000000005

-rw-------  1 postgres postgres 9.2K Mar 24 08:24 000000D9.history

-rw-------  1 postgres postgres  16M Mar 24 09:09 000000DA0000000000000005

-rw-------  1 postgres postgres 9.3K Mar 24 08:59 000000DA.history

-rw-------  1 postgres postgres  16M Mar 24 11:06 000000DB0000000000000005

-rw-------  1 postgres postgres 9.3K Mar 24 09:09 000000DB.history

-rw-------  1 postgres postgres  16M Mar 24 11:14 000000DC0000000000000005

-rw-------  1 postgres postgres 9.4K Mar 24 11:06 000000DC.history

-rw-------  1 postgres postgres  16M Mar 24 15:33 000000DD0000000000000005

-rw-------  1 postgres postgres 9.4K Mar 24 11:14 000000DD.history

-rw-------  1 postgres postgres  16M Mar 24 16:33 000000DE0000000000000005

-rw-------  1 postgres postgres 9.4K Mar 24 15:33 000000DE.history

-rw-------  1 postgres postgres  16M Mar 24 19:37 000000DF0000000000000005

-rw-------  1 postgres postgres 9.5K Mar 24 16:33 000000DF.history

-rw-------  1 postgres postgres  16M Mar 24 19:54 000000E00000000000000005

-rw-------  1 postgres postgres 9.5K Mar 24 19:37 000000E0.history

-rw-------  1 postgres postgres  16M Mar 24 22:02 000000E10000000000000005

-rw-------  1 postgres postgres 9.6K Mar 24 19:54 000000E1.history

-rw-------  1 postgres postgres  16M Mar 25 06:31 000000E20000000000000005

-rw-------  1 postgres postgres 9.6K Mar 24 22:02 000000E2.history

-rw-------  1 postgres postgres  16M Mar 25 07:08 000000E30000000000000005

-rw-------  1 postgres postgres 9.7K Mar 25 06:31 000000E3.history

-rw-------  1 postgres postgres  16M Mar 25 08:44 000000E40000000000000005

-rw-------  1 postgres postgres 9.7K Mar 25 07:08 000000E4.history

-rw-------  1 postgres postgres  16M Mar 25 09:13 000000E50000000000000005

-rw-------  1 postgres postgres 9.7K Mar 25 08:44 000000E5.history

-rw-------  1 postgres postgres  16M Mar 25 09:29 000000E60000000000000005

-rw-------  1 postgres postgres 9.8K Mar 25 09:13 000000E6.history

-rw-------  1 postgres postgres  16M Mar 25 09:54 000000E70000000000000005

-rw-------  1 postgres postgres 9.8K Mar 25 09:29 000000E7.history

-rw-------  1 postgres postgres  16M Mar 25 10:37 000000E80000000000000005

-rw-------  1 postgres postgres 9.9K Mar 25 09:54 000000E8.history

-rw-------  1 postgres postgres  16M Mar 25 13:43 000000E90000000000000005

-rw-------  1 postgres postgres 9.9K Mar 25 10:37 000000E9.history

-rw-------  1 postgres postgres  16M Mar 25 13:52 000000EA0000000000000005

-rw-------  1 postgres postgres  10K Mar 25 13:43 000000EA.history

-rw-------  1 postgres postgres  16M Mar 25 14:15 000000EB0000000000000005

-rw-------  1 postgres postgres  10K Mar 25 13:52 000000EB.history

-rw-------  1 postgres postgres  16M Mar 25 14:29 000000EC0000000000000005

-rw-------  1 postgres postgres  10K Mar 25 14:15 000000EC.history

-rw-------  1 postgres postgres  16M Mar 25 15:03 000000ED0000000000000005

-rw-------  1 postgres postgres  11K Mar 25 14:29 000000ED.history

-rw-------  1 postgres postgres  16M Mar 25 16:42 000000EE0000000000000005

-rw-------  1 postgres postgres  11K Mar 25 15:03 000000EE.history

-rw-------  1 postgres postgres  16M Mar 25 18:34 000000EF0000000000000005

-rw-------  1 postgres postgres  11K Mar 25 16:42 000000EF.history

-rw-------  1 postgres postgres  16M Mar 25 19:23 000000F00000000000000005

-rw-------  1 postgres postgres  11K Mar 25 18:34 000000F0.history

-rw-------  1 postgres postgres  16M Mar 25 22:20 000000F10000000000000005

-rw-------  1 postgres postgres  11K Mar 25 19:23 000000F1.history

-rw-------  1 postgres postgres  16M Mar 26 09:32 000000F20000000000000005

-rw-------  1 postgres postgres  11K Mar 26 01:22 000000F2.history

-rw-------  1 postgres postgres  16M Mar 26 09:33 000000F30000000000000005

-rw-------  1 postgres postgres  16M Mar 26 09:33 000000F30000000000000006

-rw-------  1 postgres postgres  16M Mar 26 09:33 000000F30000000000000007

-rw-------  1 postgres postgres  16M Mar 26 09:33 000000F30000000000000008

-rw-------  1 postgres postgres  16M Mar 26 09:38 000000F30000000000000009

-rw-------  1 postgres postgres  11K Mar 26 09:32 000000F3.history

drwx------  2 postgres postgres  12K Mar 26 10:56 archive_status

db-pg-0:/var/lib/postgresql/data/pgdata #

 

BRs,

Fan Liu