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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers