From: | Fan Liu <fan(dot)liu(at)ericsson(dot)com> |
---|---|
To: | "depesz(at)depesz(dot)com" <depesz(at)depesz(dot)com> |
Cc: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | RE: BUG #16317: max_wal_size does not remove WAL files, cause "no space left" |
Date: | 2020-03-26 01:06:03 |
Message-ID: | HE1PR0701MB25697E2589FFF3A12D43385A9ECF0@HE1PR0701MB2569.eurprd07.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
>
>-----Original Message-----
>From: depesz(at)depesz(dot)com <depesz(at)depesz(dot)com>
>Sent: 2020年3月25日 23:05
>To: Fan Liu <fan(dot)liu(at)ericsson(dot)com>
>Cc: pgsql-bugs(at)lists(dot)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | PG Bug reporting form | 2020-03-26 03:04:38 | BUG #16318: The default tablespace of a table and index is not inheriting the tablespace of database |
Previous Message | legrand legrand | 2020-03-25 22:39:03 | Re: pg_stat_statements: rows not updated for CREATE TABLE AS SELECT statements |