On 2015-03-26 13:55:22 +0000, Thom Brown wrote:
> I still, however, have a problem with the separate and original issue of:
>
> # insert into utest (thing) values ('moomoo');
> ERROR: index "utest_pkey" contains unexpected zero page at block 0
> HINT: Please REINDEX it.
>
> I don't see why the user should need to go re-indexing all unlogged tables
> each time a standby is promoted. The index should just be empty and ready
> to use.
There's definitely something rather broken here. Investigating.
Greetings,
Andres Freund
-- Andres Freund http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services