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
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
