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] user=,db= HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry. Nov 14 18:24:01 uno postgres84[24208]: [2-1] user=,db= LOG: database system was interrupted while in recovery at 2012-11-14 18:18:42 MSK Nov 14 18:24:01 uno postgres84[24208]: [2-2] user=,db= HINT: This probably means that some data is corrupted and you will have to use the last backup for re covery. Nov 14 18:24:01 uno postgres84[24208]: [3-1] user=,db= LOG: database system was not properly shut down; automatic recovery in progress Nov 14 18:24:01 uno postgres84[24208]: [4-1] user=,db= LOG: redo starts at 237B/78806EC8 Nov 14 18:24:04 uno postgres84[24208]: [5-1] user=,db= LOG: unexpected pageaddr 237B/50A1E000 in log file 9083, segment 144, offset 10608640 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[24208]: [7-1] user=,db= LOG: last completed transaction was at log time 2012-11-10 10:26:28.484922+04 Nov 14 18:24:04 uno postgres84[24208]: [8-1] user=,db= FATAL: index "316879235" contains unexpected zero page at block 264 Nov 14 18:24:04 uno postgres84[24208]: [8-2] user=,db= HINT: Please REINDEX it. Nov 14 18:24:04 uno postgres84[24207]: [2-1] user=,db= LOG: startup process (PID 24208) exited with exit code 1 Nov 14 18:24:04 uno postgres84[24207]: [3-1] user=,db= LOG: aborting startup due to startup process failure When I trying to run in a single mode: postgres --single -D /opt/postgresql/data -P postgres 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? -- Cheers, Dmitriy
