Re: log files - Mailing list pgsql-novice
| From | jjurban |
|---|---|
| Subject | Re: log files |
| Date | |
| Msg-id | 5193DB8B.60908@attglobal.net Whole thread Raw |
| In response to | Re: log files (Amit Langote <amitlangote09@gmail.com>) |
| Responses |
Re: log files
Re: log files |
| List | pgsql-novice |
Thank you for your reply. But the number and size of these WAL files is outrageous. Please see the structure listed below. There are over 5.7 Gigabytes of these files. This cannot be correct. Which of these can I remove? What can I do to avoid generating these monstrous files? Thank you. John ===== structure of WAL files ================================= 188416 0 0 11-16-07 12:29 PGSData/pg_subtrans/0015 16777216 0 0 11-16-07 17:49 PGSData/pg_xlog/00000001000000000000006B 16777216 0 0 10-26-07 10:01 PGSData/pg_xlog/00000001000000000000006C 16777216 0 0 10-30-07 11:09 PGSData/pg_xlog/00000001000000000000006D 16777216 0 0 12-07-07 21:17 PGSData/pg_xlog/00000001000000000000006E 16777216 0 0 12-07-07 21:18 PGSData/pg_xlog/00000001000000000000006F 16777216 0 0 11-12-07 10:50 PGSData/pg_xlog/000000010000000000000070 245760 0 0 01-11-08 13:40 PGSData/pg_subtrans/0016 16777216 0 0 12-21-07 19:10 PGSData/pg_xlog/000000010000000000000071 16777216 0 0 12-28-07 18:18 PGSData/pg_xlog/000000010000000000000072 16777216 0 0 12-03-07 10:46 PGSData/pg_xlog/000000010000000000000073 16777216 0 0 01-04-08 18:55 PGSData/pg_xlog/000000010000000000000074 16777216 0 0 01-11-08 19:32 PGSData/pg_xlog/000000010000000000000075 16777216 0 0 01-18-08 20:45 PGSData/pg_xlog/000000010000000000000076 16777216 0 0 01-18-08 20:48 PGSData/pg_xlog/000000010000000000000077 16777216 0 0 01-25-08 21:14 PGSData/pg_xlog/000000010000000000000078 16777216 0 0 02-01-08 21:19 PGSData/pg_xlog/000000010000000000000079 16777216 0 0 02-01-08 21:19 PGSData/pg_xlog/00000001000000000000007A 16777216 0 0 02-08-08 18:41 PGSData/pg_xlog/00000001000000000000007B 262144 0 0 02-28-08 14:34 PGSData/pg_subtrans/0017 16777216 0 0 02-15-08 22:46 PGSData/pg_xlog/00000001000000000000007C 16777216 0 0 01-18-08 20:45 PGSData/pg_xlog/00000001000000000000007D 16777216 0 0 02-29-08 22:15 PGSData/pg_xlog/00000001000000000000007E 16777216 0 0 02-29-08 22:16 PGSData/pg_xlog/00000001000000000000007F 16777216 0 0 02-01-08 21:19 PGSData/pg_xlog/000000010000000000000080 16777216 0 0 03-07-08 19:02 PGSData/pg_xlog/000000010000000000000081 16777216 0 0 03-14-08 23:09 PGSData/pg_xlog/000000010000000000000082 16777216 0 0 03-20-08 19:29 PGSData/pg_xlog/000000010000000000000083 16777216 0 0 03-20-08 19:29 PGSData/pg_xlog/000000010000000000000084 245760 0 0 04-11-08 11:03 PGSData/pg_subtrans/0018 16777216 0 0 03-28-08 19:41 PGSData/pg_xlog/000000010000000000000085 16777216 0 0 03-05-08 09:58 PGSData/pg_xlog/000000010000000000000086 16777216 0 0 04-04-08 21:59 PGSData/pg_xlog/000000010000000000000087 16777216 0 0 04-04-08 21:59 PGSData/pg_xlog/000000010000000000000088 16777216 0 0 04-18-08 18:07 PGSData/pg_xlog/000000010000000000000089 16777216 0 0 04-18-08 18:08 PGSData/pg_xlog/00000001000000000000008A 16777216 0 0 05-02-08 19:37 PGSData/pg_xlog/00000001000000000000008B 16777216 0 0 05-02-08 19:37 PGSData/pg_xlog/00000001000000000000008C 16777216 0 0 05-09-08 21:08 PGSData/pg_xlog/00000001000000000000008D 16777216 0 0 05-16-08 09:17 PGSData/pg_xlog/00000001000000000000008E 16777216 0 0 05-23-08 22:14 PGSData/pg_xlog/00000001000000000000008F 253952 0 0 06-06-08 21:12 PGSData/pg_subtrans/0019 16777216 0 0 05-30-08 21:36 PGSData/pg_xlog/000000010000000000000090 16777216 0 0 04-28-08 03:11 PGSData/pg_xlog/000000010000000000000091 16777216 0 0 06-06-08 21:12 PGSData/pg_xlog/000000010000000000000092 16777216 0 0 06-13-08 21:22 PGSData/pg_xlog/000000010000000000000093 16777216 0 0 06-13-08 21:22 PGSData/pg_xlog/000000010000000000000094 16777216 0 0 06-20-08 23:25 PGSData/pg_xlog/000000010000000000000095 16777216 0 0 06-27-08 21:44 PGSData/pg_xlog/000000010000000000000096 16777216 0 0 07-03-08 21:39 PGSData/pg_xlog/000000010000000000000097 16777216 0 0 06-02-08 20:37 PGSData/pg_xlog/000000010000000000000098 229376 0 0 07-24-08 10:30 PGSData/pg_subtrans/001A 16777216 0 0 07-11-08 22:57 PGSData/pg_xlog/000000010000000000000099 16777216 0 0 07-11-08 22:57 PGSData/pg_xlog/00000001000000000000009A 16777216 0 0 07-25-08 23:04 PGSData/pg_xlog/00000001000000000000009B 16777216 0 0 06-25-08 10:39 PGSData/pg_xlog/00000001000000000000009C 16777216 0 0 06-30-08 18:28 PGSData/pg_xlog/00000001000000000000009D 16777216 0 0 07-07-08 18:51 PGSData/pg_xlog/00000001000000000000009E 16777216 0 0 08-08-08 16:52 PGSData/pg_xlog/00000001000000000000009F 16777216 0 0 08-15-08 19:45 PGSData/pg_xlog/0000000100000000000000A0 16777216 0 0 08-29-08 20:37 PGSData/pg_xlog/0000000100000000000000A1 262144 0 0 09-17-08 10:14 PGSData/pg_subtrans/001B 16777216 0 0 08-29-08 20:38 PGSData/pg_xlog/0000000100000000000000A2 16777216 0 0 08-01-08 15:11 PGSData/pg_xlog/0000000100000000000000A3 16777216 0 0 09-05-08 23:04 PGSData/pg_xlog/0000000100000000000000A4 16777216 0 0 08-08-08 16:50 PGSData/pg_xlog/0000000100000000000000A5 16777216 0 0 09-19-08 22:26 PGSData/pg_xlog/0000000100000000000000A6 16777216 0 0 09-26-08 22:21 PGSData/pg_xlog/0000000100000000000000A7 16777216 0 0 08-29-08 20:37 PGSData/pg_xlog/0000000100000000000000A8 16777216 0 0 10-03-08 23:20 PGSData/pg_xlog/0000000100000000000000A9 16777216 0 0 10-10-08 21:05 PGSData/pg_xlog/0000000100000000000000AA 16777216 0 0 10-17-08 23:34 PGSData/pg_xlog/0000000100000000000000AB 16777216 0 0 10-17-08 23:34 PGSData/pg_xlog/0000000100000000000000AC 262144 0 0 11-06-08 13:38 PGSData/pg_subtrans/001C 16777216 0 0 09-23-08 14:38 PGSData/pg_xlog/0000000100000000000000AD 16777216 0 0 11-07-08 18:47 PGSData/pg_xlog/0000000100000000000000AE 16777216 0 0 11-07-08 18:48 PGSData/pg_xlog/0000000100000000000000AF 16777216 0 0 11-14-08 21:46 PGSData/pg_xlog/0000000100000000000000B0 16777216 0 0 10-10-08 21:05 PGSData/pg_xlog/0000000100000000000000B1 16777216 0 0 12-03-08 14:39 PGSData/pg_xlog/0000000100000000000000B2 16777216 0 0 12-05-08 22:11 PGSData/pg_xlog/0000000100000000000000B3 16777216 0 0 12-12-08 17:11 PGSData/pg_xlog/0000000100000000000000B4 172032 0 0 12-12-08 13:30 PGSData/pg_subtrans/001D 16777216 0 0 11-07-08 18:47 PGSData/pg_xlog/0000000100000000000000B5 16777216 0 0 11-10-08 12:25 PGSData/pg_xlog/0000000100000000000000B6 16777216 0 0 01-09-09 23:38 PGSData/pg_xlog/0000000100000000000000B7 16777216 0 0 01-09-09 23:39 PGSData/pg_xlog/0000000100000000000000B8 16777216 0 0 01-16-09 22:47 PGSData/pg_xlog/0000000100000000000000B9 16777216 0 0 01-23-09 21:55 PGSData/pg_xlog/0000000100000000000000BA 245760 0 0 02-19-09 23:21 PGSData/pg_subtrans/001E 16777216 0 0 01-30-09 21:26 PGSData/pg_xlog/0000000100000000000000BB 16777216 0 0 01-30-09 21:28 PGSData/pg_xlog/0000000100000000000000BC 16777216 0 0 02-06-09 21:06 PGSData/pg_xlog/0000000100000000000000BD 16777216 0 0 02-13-09 21:25 PGSData/pg_xlog/0000000100000000000000BE 16777216 0 0 02-13-09 21:26 PGSData/pg_xlog/0000000100000000000000BF 16777216 0 0 02-20-09 23:07 PGSData/pg_xlog/0000000100000000000000C0 16777216 0 0 02-27-09 21:14 PGSData/pg_xlog/0000000100000000000000C1 16777216 0 0 03-06-09 22:11 PGSData/pg_xlog/0000000100000000000000C2 16777216 0 0 03-13-09 23:03 PGSData/pg_xlog/0000000100000000000000C3 16777216 0 0 03-20-09 22:33 PGSData/pg_xlog/0000000100000000000000C4 16777216 0 0 03-27-09 22:14 PGSData/pg_xlog/0000000100000000000000C5 16777216 0 0 04-03-09 23:13 PGSData/pg_xlog/0000000100000000000000C6 180224 0 0 04-01-09 15:36 PGSData/pg_subtrans/001F 16777216 0 0 02-24-09 12:59 PGSData/pg_xlog/0000000100000000000000C7 16777216 0 0 03-02-09 09:54 PGSData/pg_xlog/0000000100000000000000C8 16777216 0 0 04-24-09 21:26 PGSData/pg_xlog/0000000100000000000000C9 16777216 0 0 04-24-09 21:26 PGSData/pg_xlog/0000000100000000000000CA 16777216 0 0 05-01-09 21:55 PGSData/pg_xlog/0000000100000000000000CB 16777216 0 0 05-15-09 22:55 PGSData/pg_xlog/0000000100000000000000CC 262144 0 0 08-29-11 00:11 PGSData/pg_clog/0002 221184 0 0 06-04-09 22:23 PGSData/pg_subtrans/0020 16777216 0 0 05-22-09 22:06 PGSData/pg_xlog/0000000100000000000000CD 16777216 0 0 05-29-09 22:03 PGSData/pg_xlog/0000000100000000000000CE 16777216 0 0 04-20-09 10:16 PGSData/pg_xlog/0000000100000000000000CF 16777216 0 0 06-05-09 19:19 PGSData/pg_xlog/0000000100000000000000D0 16777216 0 0 06-19-09 21:44 PGSData/pg_xlog/0000000100000000000000D1 16777216 0 0 06-26-09 22:42 PGSData/pg_xlog/0000000100000000000000D2 16777216 0 0 06-26-09 22:43 PGSData/pg_xlog/0000000100000000000000D3 16777216 0 0 07-02-09 22:53 PGSData/pg_xlog/0000000100000000000000D4 16777216 0 0 07-10-09 22:40 PGSData/pg_xlog/0000000100000000000000D5 16777216 0 0 07-17-09 20:51 PGSData/pg_xlog/0000000100000000000000D6 196608 0 0 07-30-09 09:34 PGSData/pg_subtrans/0021 16777216 0 0 07-31-09 23:40 PGSData/pg_xlog/0000000100000000000000D7 16777216 0 0 06-19-09 21:44 PGSData/pg_xlog/0000000100000000000000D8 16777216 0 0 08-14-09 22:09 PGSData/pg_xlog/0000000100000000000000D9 16777216 0 0 08-21-09 23:13 PGSData/pg_xlog/0000000100000000000000DA 16777216 0 0 08-28-09 22:39 PGSData/pg_xlog/0000000100000000000000DB 16777216 0 0 08-28-09 22:39 PGSData/pg_xlog/0000000100000000000000DC 16777216 0 0 09-13-09 20:38 PGSData/pg_xlog/0000000100000000000000DD 253952 0 0 10-09-09 09:08 PGSData/pg_subtrans/0022 16777216 0 0 09-19-09 23:37 PGSData/pg_xlog/0000000100000000000000DE 16777216 0 0 09-25-09 22:08 PGSData/pg_xlog/0000000100000000000000DF 16777216 0 0 08-14-09 22:09 PGSData/pg_xlog/0000000100000000000000E0 16777216 0 0 08-24-09 06:53 PGSData/pg_xlog/0000000100000000000000E1 16777216 0 0 10-10-09 23:49 PGSData/pg_xlog/0000000100000000000000E2 16777216 0 0 10-23-09 20:29 PGSData/pg_xlog/0000000100000000000000E3 16777216 0 0 10-30-09 21:55 PGSData/pg_xlog/0000000100000000000000E4 16777216 0 0 11-06-09 20:36 PGSData/pg_xlog/0000000100000000000000E5 16777216 0 0 11-13-09 23:54 PGSData/pg_xlog/0000000100000000000000E6 16777216 0 0 10-05-09 20:34 PGSData/pg_xlog/0000000100000000000000E7 16777216 0 0 11-25-09 22:18 PGSData/pg_xlog/0000000100000000000000E8 262144 0 0 12-04-09 10:56 PGSData/pg_subtrans/0023 16777216 0 0 10-19-09 11:49 PGSData/pg_xlog/0000000100000000000000E9 16777216 0 0 12-04-09 23:22 PGSData/pg_xlog/0000000100000000000000EA 16777216 0 0 12-11-09 21:30 PGSData/pg_xlog/0000000100000000000000EB 16777216 0 0 12-23-09 17:26 PGSData/pg_xlog/0000000100000000000000EC 16777216 0 0 12-31-09 16:47 PGSData/pg_xlog/0000000100000000000000ED 16777216 0 0 12-31-09 16:48 PGSData/pg_xlog/0000000100000000000000EE 16777216 0 0 01-08-10 23:47 PGSData/pg_xlog/0000000100000000000000EF 16777216 0 0 01-15-10 21:43 PGSData/pg_xlog/0000000100000000000000F0 262144 0 0 01-22-10 07:52 PGSData/pg_subtrans/0024 16777216 0 0 01-22-10 21:17 PGSData/pg_xlog/0000000100000000000000F1 16777216 0 0 01-29-10 22:07 PGSData/pg_xlog/0000000100000000000000F2 16777216 0 0 12-23-09 17:26 PGSData/pg_xlog/0000000100000000000000F3 16777216 0 0 02-12-10 17:29 PGSData/pg_xlog/0000000100000000000000F4 16777216 0 0 02-19-10 20:33 PGSData/pg_xlog/0000000100000000000000F5 16777216 0 0 02-26-10 21:05 PGSData/pg_xlog/0000000100000000000000F6 16777216 0 0 03-05-10 16:27 PGSData/pg_xlog/0000000100000000000000F7 253952 0 0 03-15-10 16:48 PGSData/pg_subtrans/0025 16777216 0 0 03-12-10 21:11 PGSData/pg_xlog/0000000100000000000000F8 16777216 0 0 03-19-10 19:09 PGSData/pg_xlog/0000000100000000000000F9 16777216 0 0 03-26-10 21:55 PGSData/pg_xlog/0000000100000000000000FA 16777216 0 0 04-01-10 18:22 PGSData/pg_xlog/0000000100000000000000FB 16777216 0 0 04-09-10 21:45 PGSData/pg_xlog/0000000100000000000000FC 16777216 0 0 03-03-10 10:11 PGSData/pg_xlog/0000000100000000000000FD 16777216 0 0 04-30-10 21:25 PGSData/pg_xlog/0000000100000000000000FE 16777216 0 0 05-07-10 18:15 PGSData/pg_xlog/000000010000000100000000 237568 0 0 05-04-10 19:04 PGSData/pg_subtrans/0026 16777216 0 0 05-07-10 18:15 PGSData/pg_xlog/000000010000000100000001 16777216 0 0 05-14-10 23:13 PGSData/pg_xlog/000000010000000100000002 16777216 0 0 04-07-10 19:00 PGSData/pg_xlog/000000010000000100000003 16777216 0 0 06-04-10 21:06 PGSData/pg_xlog/000000010000000100000004 16777216 0 0 06-04-10 21:07 PGSData/pg_xlog/000000010000000100000005 16777216 0 0 04-30-10 21:25 PGSData/pg_xlog/000000010000000100000006 237568 0 0 06-24-10 22:31 PGSData/pg_subtrans/0027 16777216 0 0 06-18-10 20:18 PGSData/pg_xlog/000000010000000100000007 16777216 0 0 06-25-10 22:02 PGSData/pg_xlog/000000010000000100000008 16777216 0 0 07-09-10 23:28 PGSData/pg_xlog/000000010000000100000009 16777216 0 0 07-09-10 23:29 PGSData/pg_xlog/00000001000000010000000A 16777216 0 0 07-16-10 20:33 PGSData/pg_xlog/00000001000000010000000B 16777216 0 0 07-23-10 19:11 PGSData/pg_xlog/00000001000000010000000C 16777216 0 0 07-30-10 22:03 PGSData/pg_xlog/00000001000000010000000D 16777216 0 0 08-13-10 22:31 PGSData/pg_xlog/00000001000000010000000E 196608 0 0 08-12-10 17:54 PGSData/pg_subtrans/0028 16777216 0 0 08-13-10 22:32 PGSData/pg_xlog/00000001000000010000000F 16777216 0 0 07-09-10 23:28 PGSData/pg_xlog/000000010000000100000010 16777216 0 0 09-04-10 22:01 PGSData/pg_xlog/000000010000000100000011 16777216 0 0 09-10-10 20:35 PGSData/pg_xlog/000000010000000100000012 16777216 0 0 07-26-10 18:48 PGSData/pg_xlog/000000010000000100000013 16777216 0 0 09-24-10 23:43 PGSData/pg_xlog/000000010000000100000014 262144 0 0 10-16-10 11:13 PGSData/pg_subtrans/0029 16777216 0 0 08-13-10 22:31 PGSData/pg_xlog/000000010000000100000015 16777216 0 0 10-08-10 20:50 PGSData/pg_xlog/000000010000000100000016 16777216 0 0 10-08-10 20:51 PGSData/pg_xlog/000000010000000100000017 16777216 0 0 10-16-10 20:27 PGSData/pg_xlog/000000010000000100000018 16777216 0 0 09-13-10 13:00 PGSData/pg_xlog/000000010000000100000019 16777216 0 0 10-29-10 21:15 PGSData/pg_xlog/00000001000000010000001A 16777216 0 0 11-05-10 22:57 PGSData/pg_xlog/00000001000000010000001B 16777216 0 0 11-12-10 21:12 PGSData/pg_xlog/00000001000000010000001C 16777216 0 0 11-24-10 22:27 PGSData/pg_xlog/00000001000000010000001D 16777216 0 0 11-24-10 22:27 PGSData/pg_xlog/00000001000000010000001E 262144 0 0 12-03-10 16:38 PGSData/pg_subtrans/002A 16777216 0 0 12-03-10 16:38 PGSData/pg_xlog/00000001000000010000001F 16777216 0 0 12-10-10 16:54 PGSData/pg_xlog/000000010000000100000020 16777216 0 0 12-17-10 20:37 PGSData/pg_xlog/000000010000000100000021 16777216 0 0 11-11-10 22:12 PGSData/pg_xlog/000000010000000100000022 16777216 0 0 01-07-11 20:10 PGSData/pg_xlog/000000010000000100000023 16777216 0 0 01-07-11 20:11 PGSData/pg_xlog/000000010000000100000024 16777216 0 0 01-14-11 23:26 PGSData/pg_xlog/000000010000000100000025 237568 0 0 01-21-11 10:51 PGSData/pg_subtrans/002B 16777216 0 0 01-21-11 21:32 PGSData/pg_xlog/000000010000000100000026 16777216 0 0 01-28-11 22:35 PGSData/pg_xlog/000000010000000100000027 16777216 0 0 02-05-11 14:52 PGSData/pg_xlog/000000010000000100000028 16777216 0 0 02-11-11 20:34 PGSData/pg_xlog/000000010000000100000029 16777216 0 0 02-18-11 23:04 PGSData/pg_xlog/00000001000000010000002A 16777216 0 0 01-14-11 14:01 PGSData/pg_xlog/00000001000000010000002B 16777216 0 0 03-04-11 17:43 PGSData/pg_xlog/00000001000000010000002C 237568 0 0 03-09-11 11:35 PGSData/pg_subtrans/002C 16777216 0 0 03-11-11 21:46 PGSData/pg_xlog/00000001000000010000002D 16777216 0 0 03-18-11 21:35 PGSData/pg_xlog/00000001000000010000002E 16777216 0 0 03-18-11 21:44 PGSData/pg_xlog/00000001000000010000002F 16777216 0 0 03-25-11 17:25 PGSData/pg_xlog/000000010000000100000030 16777216 0 0 04-01-11 19:49 PGSData/pg_xlog/000000010000000100000031 16777216 0 0 04-08-11 17:59 PGSData/pg_xlog/000000010000000100000032 16777216 0 0 04-15-11 18:01 PGSData/pg_xlog/000000010000000100000033 245760 0 0 04-28-11 14:31 PGSData/pg_subtrans/002D 16777216 0 0 04-21-11 18:46 PGSData/pg_xlog/000000010000000100000034 16777216 0 0 04-21-11 18:47 PGSData/pg_xlog/000000010000000100000035 16777216 0 0 05-06-11 16:59 PGSData/pg_xlog/000000010000000100000036 16777216 0 0 05-13-11 23:55 PGSData/pg_xlog/000000010000000100000037 16777216 0 0 05-21-11 15:27 PGSData/pg_xlog/000000010000000100000038 16777216 0 0 05-27-11 21:42 PGSData/pg_xlog/000000010000000100000039 16777216 0 0 06-03-11 20:09 PGSData/pg_xlog/00000001000000010000003A 16777216 0 0 06-10-11 17:06 PGSData/pg_xlog/00000001000000010000003B 16777216 0 0 06-17-11 19:06 PGSData/pg_xlog/00000001000000010000003C 262144 0 0 06-30-11 14:19 PGSData/pg_subtrans/002E 16777216 0 0 06-24-11 16:53 PGSData/pg_xlog/00000001000000010000003D 16777216 0 0 07-01-11 21:33 PGSData/pg_xlog/00000001000000010000003E 16777216 0 0 07-08-11 17:20 PGSData/pg_xlog/00000001000000010000003F 16777216 0 0 07-15-11 16:34 PGSData/pg_xlog/000000010000000100000040 16777216 0 0 07-22-11 20:04 PGSData/pg_xlog/000000010000000100000041 16777216 0 0 07-29-11 16:03 PGSData/pg_xlog/000000010000000100000042 16777216 0 0 08-05-11 18:30 PGSData/pg_xlog/000000010000000100000043 16777216 0 0 08-12-11 17:13 PGSData/pg_xlog/000000010000000100000044 262144 0 0 08-26-11 11:20 PGSData/pg_subtrans/002F 16777216 0 0 08-19-11 20:38 PGSData/pg_xlog/000000010000000100000045 16777216 0 0 08-26-11 20:20 PGSData/pg_xlog/000000010000000100000046 16777216 0 0 09-02-11 18:03 PGSData/pg_xlog/000000010000000100000047 16777216 0 0 09-09-11 21:04 PGSData/pg_xlog/000000010000000100000048 16777216 0 0 09-16-11 17:33 PGSData/pg_xlog/000000010000000100000049 16777216 0 0 09-23-11 16:52 PGSData/pg_xlog/00000001000000010000004A 16777216 0 0 09-23-11 16:53 PGSData/pg_xlog/00000001000000010000004B 16777216 0 0 09-30-11 21:20 PGSData/pg_xlog/00000001000000010000004C 245760 0 0 05-10-13 13:51 PGSData/pg_clog/0003 229376 0 0 10-05-11 10:51 PGSData/pg_subtrans/0030 16777216 0 0 10-07-11 20:52 PGSData/pg_xlog/00000001000000010000004D 16777216 0 0 10-14-11 20:15 PGSData/pg_xlog/00000001000000010000004E 16777216 0 0 10-14-11 20:16 PGSData/pg_xlog/00000001000000010000004F 16777216 0 0 10-28-11 18:45 PGSData/pg_xlog/000000010000000100000050 16777216 0 0 10-28-11 18:47 PGSData/pg_xlog/000000010000000100000051 16777216 0 0 11-04-11 21:04 PGSData/pg_xlog/000000010000000100000052 16777216 0 0 09-30-11 21:20 PGSData/pg_xlog/000000010000000100000053 245760 0 0 11-23-11 18:32 PGSData/pg_subtrans/0031 16777216 0 0 10-10-11 04:34 PGSData/pg_xlog/000000010000000100000054 16777216 0 0 11-24-11 01:52 PGSData/pg_xlog/000000010000000100000055 16777216 0 0 11-24-11 01:53 PGSData/pg_xlog/000000010000000100000056 16777216 0 0 12-09-11 20:16 PGSData/pg_xlog/000000010000000100000057 16777216 0 0 12-09-11 20:18 PGSData/pg_xlog/000000010000000100000058 16777216 0 0 12-17-11 17:18 PGSData/pg_xlog/000000010000000100000059 16777216 0 0 12-22-11 17:28 PGSData/pg_xlog/00000001000000010000005A 16777216 0 0 12-30-11 22:00 PGSData/pg_xlog/00000001000000010000005B 237568 0 0 01-12-12 13:31 PGSData/pg_subtrans/0032 16777216 0 0 11-24-11 01:52 PGSData/pg_xlog/00000001000000010000005C 16777216 0 0 01-14-12 17:49 PGSData/pg_xlog/00000001000000010000005D 16777216 0 0 01-21-12 19:12 PGSData/pg_xlog/00000001000000010000005E 16777216 0 0 12-15-11 10:06 PGSData/pg_xlog/00000001000000010000005F 16777216 0 0 01-28-12 15:39 PGSData/pg_xlog/000000010000000100000060 16777216 0 0 12-23-11 17:35 PGSData/pg_xlog/000000010000000100000061 16777216 0 0 02-10-12 17:03 PGSData/pg_xlog/000000010000000100000062 16777216 0 0 02-10-12 17:05 PGSData/pg_xlog/000000010000000100000063 245760 0 0 02-24-12 13:56 PGSData/pg_subtrans/0033 16777216 0 0 01-16-12 19:06 PGSData/pg_xlog/000000010000000100000064 16777216 0 0 02-24-12 16:00 PGSData/pg_xlog/000000010000000100000065 16777216 0 0 01-27-12 02:02 PGSData/pg_xlog/000000010000000100000066 16777216 0 0 01-30-12 01:16 PGSData/pg_xlog/000000010000000100000067 16777216 0 0 03-09-12 21:21 PGSData/pg_xlog/000000010000000100000068 16777216 0 0 02-10-12 17:03 PGSData/pg_xlog/000000010000000100000069 16777216 0 0 03-25-12 00:43 PGSData/pg_xlog/00000001000000010000006A 16777216 0 0 03-25-12 00:45 PGSData/pg_xlog/00000001000000010000006B 237568 0 0 04-02-12 06:30 PGSData/pg_subtrans/0034 16777216 0 0 04-05-12 21:12 PGSData/pg_xlog/00000001000000010000006C 16777216 0 0 04-05-12 21:13 PGSData/pg_xlog/00000001000000010000006D 16777216 0 0 03-09-12 10:36 PGSData/pg_xlog/00000001000000010000006E 16777216 0 0 04-20-12 20:18 PGSData/pg_xlog/00000001000000010000006F 16777216 0 0 04-20-12 20:19 PGSData/pg_xlog/000000010000000100000070 16777216 0 0 03-25-12 00:43 PGSData/pg_xlog/000000010000000100000071 16777216 0 0 03-29-12 12:03 PGSData/pg_xlog/000000010000000100000072 221184 0 0 05-11-12 13:32 PGSData/pg_subtrans/0035 16777216 0 0 05-11-12 21:28 PGSData/pg_xlog/000000010000000100000073 16777216 0 0 04-12-12 08:41 PGSData/pg_xlog/000000010000000100000074 16777216 0 0 04-17-12 14:29 PGSData/pg_xlog/000000010000000100000075 16777216 0 0 04-20-12 20:18 PGSData/pg_xlog/000000010000000100000076 16777216 0 0 06-03-12 00:33 PGSData/pg_xlog/000000010000000100000077 16777216 0 0 05-05-12 13:45 PGSData/pg_xlog/000000010000000100000078 16777216 0 0 05-11-12 10:35 PGSData/pg_xlog/000000010000000100000079 253952 0 0 06-22-12 12:43 PGSData/pg_subtrans/0036 16777216 0 0 05-12-12 08:57 PGSData/pg_xlog/00000001000000010000007A 16777216 0 0 06-15-12 21:06 PGSData/pg_xlog/00000001000000010000007B 16777216 0 0 06-15-12 21:07 PGSData/pg_xlog/00000001000000010000007C 16777216 0 0 06-22-12 17:39 PGSData/pg_xlog/00000001000000010000007D 16777216 0 0 06-04-12 00:59 PGSData/pg_xlog/00000001000000010000007E 16777216 0 0 07-06-12 18:50 PGSData/pg_xlog/00000001000000010000007F 16777216 0 0 07-06-12 18:52 PGSData/pg_xlog/000000010000000100000080 16777216 0 0 07-13-12 23:50 PGSData/pg_xlog/000000010000000100000081 16777216 0 0 07-21-12 19:15 PGSData/pg_xlog/000000010000000100000082 16777216 0 0 07-27-12 22:54 PGSData/pg_xlog/000000010000000100000083 196608 0 0 07-26-12 08:01 PGSData/pg_subtrans/0037 16777216 0 0 07-27-12 22:56 PGSData/pg_xlog/000000010000000100000084 16777216 0 0 06-29-12 21:07 PGSData/pg_xlog/000000010000000100000085 16777216 0 0 08-10-12 20:13 PGSData/pg_xlog/000000010000000100000086 16777216 0 0 08-10-12 20:15 PGSData/pg_xlog/000000010000000100000087 16777216 0 0 08-17-12 20:23 PGSData/pg_xlog/000000010000000100000088 16777216 0 0 08-24-12 16:06 PGSData/pg_xlog/000000010000000100000089 253952 0 0 09-13-12 14:41 PGSData/pg_subtrans/0038 16777216 0 0 08-24-12 16:07 PGSData/pg_xlog/00000001000000010000008A 16777216 0 0 08-31-12 20:19 PGSData/pg_xlog/00000001000000010000008B 16777216 0 0 09-07-12 22:42 PGSData/pg_xlog/00000001000000010000008C 16777216 0 0 09-14-12 21:21 PGSData/pg_xlog/00000001000000010000008D 16777216 0 0 09-21-12 18:23 PGSData/pg_xlog/00000001000000010000008E 16777216 0 0 09-28-12 15:37 PGSData/pg_xlog/00000001000000010000008F 16777216 0 0 09-28-12 15:38 PGSData/pg_xlog/000000010000000100000090 16777216 0 0 10-05-12 18:50 PGSData/pg_xlog/000000010000000100000091 16777216 0 0 10-12-12 17:41 PGSData/pg_xlog/000000010000000100000092 16777216 0 0 09-10-12 11:08 PGSData/pg_xlog/000000010000000100000093 253952 0 0 10-25-12 13:29 PGSData/pg_subtrans/0039 16777216 0 0 10-24-12 16:35 PGSData/pg_xlog/000000010000000100000094 16777216 0 0 10-31-12 17:17 PGSData/pg_xlog/000000010000000100000095 16777216 0 0 11-02-12 23:03 PGSData/pg_xlog/000000010000000100000096 16777216 0 0 11-09-12 17:08 PGSData/pg_xlog/000000010000000100000097 16777216 0 0 11-09-12 17:10 PGSData/pg_xlog/000000010000000100000098 16777216 0 0 11-16-12 17:47 PGSData/pg_xlog/000000010000000100000099 16777216 0 0 10-22-12 16:58 PGSData/pg_xlog/00000001000000010000009A 16777216 0 0 11-26-12 20:24 PGSData/pg_xlog/00000001000000010000009B 253952 0 0 12-07-12 21:45 PGSData/pg_subtrans/003A 16777216 0 0 12-07-12 21:44 PGSData/pg_xlog/00000001000000010000009C 16777216 0 0 12-07-12 21:45 PGSData/pg_xlog/00000001000000010000009D 16777216 0 0 12-14-12 20:45 PGSData/pg_xlog/00000001000000010000009E 16777216 0 0 12-21-12 23:14 PGSData/pg_xlog/00000001000000010000009F 16777216 0 0 12-29-12 20:43 PGSData/pg_xlog/0000000100000001000000A0 16777216 0 0 11-26-12 20:23 PGSData/pg_xlog/0000000100000001000000A1 16777216 0 0 01-12-13 00:17 PGSData/pg_xlog/0000000100000001000000A2 237568 0 0 01-18-13 10:46 PGSData/pg_subtrans/003B 16777216 0 0 01-19-13 00:28 PGSData/pg_xlog/0000000100000001000000A3 16777216 0 0 12-14-12 11:03 PGSData/pg_xlog/0000000100000001000000A4 16777216 0 0 01-25-13 17:45 PGSData/pg_xlog/0000000100000001000000A5 16777216 0 0 02-01-13 19:12 PGSData/pg_xlog/0000000100000001000000A6 16777216 0 0 02-01-13 19:14 PGSData/pg_xlog/0000000100000001000000A7 16777216 0 0 02-08-13 16:28 PGSData/pg_xlog/0000000100000001000000A8 16777216 0 0 02-15-13 17:10 PGSData/pg_xlog/0000000100000001000000A9 253952 0 0 03-01-13 10:37 PGSData/pg_subtrans/003C 16777216 0 0 02-22-13 17:16 PGSData/pg_xlog/0000000100000001000000AA 16777216 0 0 02-22-13 17:18 PGSData/pg_xlog/0000000100000001000000AB 16777216 0 0 03-01-13 16:43 PGSData/pg_xlog/0000000100000001000000AC 16777216 0 0 03-08-13 16:08 PGSData/pg_xlog/0000000100000001000000AD 16777216 0 0 03-15-13 18:18 PGSData/pg_xlog/0000000100000001000000AE 16777216 0 0 02-12-13 01:37 PGSData/pg_xlog/0000000100000001000000AF 16777216 0 0 03-22-13 19:14 PGSData/pg_xlog/0000000100000001000000B0 16777216 0 0 03-28-13 21:13 PGSData/pg_xlog/0000000100000001000000B1 16777216 0 0 04-05-13 19:38 PGSData/pg_xlog/0000000100000001000000B2 253952 0 0 04-12-13 17:50 PGSData/pg_subtrans/003D 16777216 0 0 04-05-13 19:45 PGSData/pg_xlog/0000000100000001000000B3 16777216 0 0 04-12-13 17:50 PGSData/pg_xlog/0000000100000001000000B4 16777216 0 0 04-20-13 00:10 PGSData/pg_xlog/0000000100000001000000B5 16777216 0 0 04-25-13 20:34 PGSData/pg_xlog/0000000100000001000000B6 16777216 0 0 05-03-13 20:51 PGSData/pg_xlog/0000000100000001000000B7 16777216 0 0 05-03-13 20:52 PGSData/pg_xlog/0000000100000001000000B8 16777216 0 0 05-10-13 11:35 PGSData/pg_xlog/0000000100000001000000B9 16777216 0 0 05-10-13 13:51 PGSData/pg_xlog/0000000100000001000000BA 163840 0 0 05-10-13 13:51 PGSData/pg_subtrans/003E 16777216 0 0 04-16-13 10:47 PGSData/pg_xlog/0000000100000001000000BB 16777216 0 0 04-23-13 08:54 PGSData/pg_xlog/0000000100000001000000BC 16777216 0 0 04-29-13 06:23 PGSData/pg_xlog/0000000100000001000000BD 16777216 0 0 05-03-13 20:51 PGSData/pg_xlog/0000000100000001000000BE 16777216 0 0 05-06-13 14:12 PGSData/pg_xlog/0000000100000001000000BF 16777216 0 0 05-10-13 11:35 PGSData/pg_xlog/0000000100000001000000C0 -------- ----- ----- ------- Total = 5.7315E+09 bytes Amit Langote wrote: > Hello John, > > Those are Write Ahead Log (WAL) file segments (16MB each) and are part > of PostgreSQL's REDO mechanism. > PostgreSQL official documentation on WAL: > > http://www.postgresql.org/docs/9.2/static/wal.html > > >> 1. Can I delete them and still continue to run? >> > > You would not be able to recover if you deleted the segments that > PostgreSQL would require for recovery. That is, if you delete WAL > segments after the last checkpoint, you would not be able to recover > consistently. Note that a checkpoint is a point in database operation, > all the data changes before which, are guaranteed to be written out to > data files (hence consistent). So, all the WAL data after the last > checkpoint is essential for consistent should the database crash, > since the data changes (that this WAL data represents) have not made > to the data files yet. Though, you wouldn't require any of WAL data > before a checkpoint (though, you may still keep old WAL files in an > archive directory different than pg_xlog to later perform a > Point-in-Time-Recovery). > > >> 2. How do I turn off the generation of these files? >> > > You can not turn off generation of these files. They are an integral > part of consistent database operation that ensure integrity and crash > safety. Though, you may control the number of such segments under > pg_xlog. I would recommend you read PostgreSQL documentation about > ways to do this. > > > -- > Amit Langote > > >
pgsql-novice by date: