Re: production server down

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