Hello, today i restarted my postgresql 9.0 instance and it won't start. The logs are 2012-01-12 14:01:59.976 MSK,,,5644,,4f0eaf97.160c,2,,2012-01-12 14:01:59 MSK,,0,LOG,00000,"database system was not properly shut down; automatic recovery in progress",,,,,,,,,"" 2012-01-12 14:01:59.976 MSK,,,5644,,4f0eaf97.160c,3,,2012-01-12 14:01:59 MSK,,0,LOG,00000,"consistent recovery state reached at 2A/7FA53250",,,,,,,,,"" 2012-01-12 14:01:59.976 MSK,,,5644,,4f0eaf97.160c,4,,2012-01-12 14:01:59 MSK,,0,LOG,00000,"redo starts at 2A/7FA53250",,,,,,,,,"" 2012-01-12 14:01:59.999 MSK,,,5644,,4f0eaf97.160c,5,,2012-01-12 14:01:59 MSK,,0,LOG,00000,"unexpected pageaddr 2A/8CE6000 in log file 42, segment 127, offset 13524992",,,,,,,,,"" 2012-01-12 14:01:59.999 MSK,,,5644,,4f0eaf97.160c,6,,2012-01-12 14:01:59 MSK,,0,LOG,00000,"redo done at 2A/7FCE5E20",,,,,,,,,"" 2012-01-12 14:01:59.999 MSK,,,5644,,4f0eaf97.160c,7,,2012-01-12 14:01:59 MSK,,0,LOG,00000,"last completed transaction was at log time 2012-01-12 13:37:40.810534+04",,,,,,,,,"" 2012-01-12 14:02:00.040 MSK,,,5644,,4f0eaf97.160c,8,,2012-01-12 14:01:59 MSK,,0,FATAL,XX002,"index ""1339592"" contains unexpected zero page at block 328134",,"Please REINDEX it.",,,,,,,"" 2012-01-12 14:02:00.042 MSK,,,5642,,4f0eaf97.160a,1,,2012-01-12 14:01:59 MSK,,0,LOG,00000,"startup process (PID 5644) exited with exit code 1",,,,,,,,,"" 2012-01-12 14:02:00.042 MSK,,,5642,,4f0eaf97.160a,2,,2012-01-12 14:01:59 MSK,,0,LOG,00000,"aborting startup due to startup process failure",,,,,,,,,"" My question is corrupted index, not transaction rollbacks. How can i rebuild index if db aint start? I was running with fsync off, how postgresql behave about index consistency with fsync on? -- Evgeny -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
