Re: production server down
От | Joe Conway |
---|---|
Тема | Re: production server down |
Дата | |
Msg-id | 41C07075.6020508@joeconway.com обсуждение исходный текст |
Ответ на | Re: production server down (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: production server down
(Tom Lane <tgl@sss.pgh.pa.us>)
|
Список | pgsql-hackers |
Tom Lane wrote: > pg_resetxlog will rebuild it in any case. However it will re-use the > existing contents as much as it can (if you don't use any of the command > line options to override values). Given Alvaro's observation that the > existing file looks suspiciously close to a freshly-initdb'd one, I > don't think you want to trust the existing contents. I don't trust it at all. So does that imply that I should override next transaction id and WAL starting address per the manpage? > > What if anything have you got in $PGDATA/pg_xlog? > # pwd /replica/pgdata/pg_xlog # ll total 688836 drwx------ 2 postgres postgres 32768 Dec 13 15:47 . drwx------ 6 postgres postgres 4096 Dec 14 17:45 .. -rw------- 1 postgres postgres 16777216 Dec 13 16:02 000001650000004E -rw------- 1 postgres postgres 16777216 Dec 13 06:42 000001650000004F -rw------- 1 postgres postgres 16777216 Dec 13 06:55 0000016500000050 -rw------- 1 postgres postgres 16777216 Dec 13 07:21 0000016500000051 -rw------- 1 postgres postgres 16777216 Dec 13 07:41 0000016500000052 -rw------- 1 postgres postgres 16777216 Dec 13 07:57 0000016500000053 -rw------- 1 postgres postgres 16777216 Dec 13 08:00 0000016500000054 -rw------- 1 postgres postgres 16777216 Dec 13 08:04 0000016500000055 -rw------- 1 postgres postgres 16777216 Dec 13 08:09 0000016500000056 -rw------- 1 postgres postgres 16777216 Dec 13 08:13 0000016500000057 -rw------- 1 postgres postgres 16777216 Dec 13 08:26 0000016500000058 -rw------- 1 postgres postgres 16777216 Dec 13 08:42 0000016500000059 -rw------- 1 postgres postgres 16777216 Dec 13 09:09 000001650000005A -rw------- 1 postgres postgres 16777216 Dec 13 09:23 000001650000005B -rw------- 1 postgres postgres 16777216 Dec 13 09:40 000001650000005C -rw------- 1 postgres postgres 16777216 Dec 13 09:51 000001650000005D -rw------- 1 postgres postgres 16777216 Dec 13 09:58 000001650000005E -rw------- 1 postgres postgres 16777216 Dec 13 10:03 000001650000005F -rw------- 1 postgres postgres 16777216 Dec 13 10:09 0000016500000060 -rw------- 1 postgres postgres 16777216 Dec 13 10:24 0000016500000061 -rw------- 1 postgres postgres 16777216 Dec 13 10:37 0000016500000062 -rw------- 1 postgres postgres 16777216 Dec 13 10:56 0000016500000063 -rw------- 1 postgres postgres 16777216 Dec 13 11:11 0000016500000064 -rw------- 1 postgres postgres 16777216 Dec 13 11:38 0000016500000065 -rw------- 1 postgres postgres 16777216 Dec 13 11:52 0000016500000066 -rw------- 1 postgres postgres 16777216 Dec 13 11:56 0000016500000067 -rw------- 1 postgres postgres 16777216 Dec 13 12:04 0000016500000068 -rw------- 1 postgres postgres 16777216 Dec 13 12:07 0000016500000069 -rw------- 1 postgres postgres 16777216 Dec 13 12:17 000001650000006A -rw------- 1 postgres postgres 16777216 Dec 13 12:29 000001650000006B -rw------- 1 postgres postgres 16777216 Dec 13 12:52 000001650000006C -rw------- 1 postgres postgres 16777216 Dec 13 13:15 000001650000006D -rw------- 1 postgres postgres 16777216 Dec 13 13:36 000001650000006E -rw------- 1 postgres postgres 16777216 Dec 13 13:51 000001650000006F -rw------- 1 postgres postgres 16777216 Dec 13 13:59 0000016500000070 -rw------- 1 postgres postgres 16777216 Dec 13 14:06 0000016500000071 -rw------- 1 postgres postgres 16777216 Dec 13 14:10 0000016500000072 -rw------- 1 postgres postgres 16777216 Dec 13 14:15 0000016500000073 -rw------- 1 postgres postgres 16777216 Dec 13 14:37 0000016500000074 -rw------- 1 postgres postgres 16777216 Dec 13 14:51 0000016500000075 -rw------- 1 postgres postgres 16777216 Dec 13 15:17 0000016500000076 -rw------- 1 postgres postgres 16777216 Dec 13 15:39 0000016500000077 Joe
В списке pgsql-hackers по дате отправления: