Re: [GENERAL] FATAL: index contains unexpected zero page at block

2012-11-16 Thread Dmitriy Tyugaev
by value Float8 argument passing: by value On Thu, Nov 15, 2012 at 2:50 AM, Tom Lane wrote: > Dmitriy Tyugaev writes: > > Nov 14 18:24:04 uno postgres84[24208]: [6-1] user=,db= LOG: redo done at > > 237B/90A1DF98 > > Nov 14 18:24:04 uno postgres84[

Re: [GENERAL] FATAL: index contains unexpected zero page at block

2012-11-16 Thread Dmitriy Tyugaev
How can I execute rebulding the index, if it does not start and I can't connect? On Thu, Nov 15, 2012 at 2:34 AM, VB N wrote: > > user=,db= FATAL: index "316879235" contains unexpected zero page at block >> 264 >> user=,db= HINT: Please REINDEX it. >> >> Please tell me what can I do to recover

[GENERAL] FATAL: index contains unexpected zero page at block

2012-11-14 Thread Dmitriy Tyugaev
Hi list, After planned rebooting the server dropped the database server PostgreSQL 8.4 When it start the server writes to the log: Nov 14 18:24:01 uno postgres84[24207]: [1-1] user=,db= LOG: could not bind IPv6 socket: Cannot assign requested address Nov 14 18:24:01 uno postgres84[24207]: [1-2]