Restoring postgresql 9.4 crashed database

From: Babacar Gningue <gningue(dot)babacar(dot)ita(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Restoring postgresql 9.4 crashed database
Date: 2016-04-11 12:29:16
Message-ID: CAKqfWWA18gWaqEg8vUQLAN9yodPUpNOEbdkhmeVz6HxVApMMyA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Can anyone help me to restore my crashed database. Is there a way to use
pg_resetxlog. I read a number of documentations telling about it but i'm
always seeing the same log when i restart my postgresql service ?

Thanks in advance

2016-04-11 8:47:59 p.m. GMT [1710-1] LOG: the database system was
interrupted during a restore at 2016-04-11 11:04:19 GMT
2016-04-11 8:47:59 p.m. GMT [1710-2] TIP: This probably means that the
data has been corrupted and you
need to use the last backup for recovery.
2016-04-11 8:47:59 p.m. GMT [1710-3] LOG: the database system was not
shut properly; restoration
automatic current
2016-04-11 8:47:59 p.m. GMT [1710-4] LOG: the re-execution starts at 4
/ 32DF8E90
2016-04-11 8:47:59 p.m. GMT [1710-5] FATAL: could not access the
transaction status 5598
2016-04-11 8:47:59 p.m. GMT [1710-6] DETAIL: Could not read the file
"pg_multixact / members / 0000" at offset 57344: Success
2016-04-11 8:47:59 p.m. GMT [1710-7] BACKGROUND: xlog redo create mxiD
5598 offset 11603 Nmembers 2: 6486476 (keysh) 6,486,482 (keysh)
2016-04-11 8:47:59 p.m. GMT [1709-1] LOG: launch process (PID 1710)
exits with exit code 1
2016-04-11 8:47:59 p.m. GMT [1709-2] LOG: start cancellation due to a
failure in the launch process

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Pavel Raiskup 2016-04-12 13:32:50 Re: Complicated re-distribution of pgjdbc the "open source way"
Previous Message Pavel Raiskup 2016-04-08 07:22:47 Re: Complicated re-distribution of pgjdbc the "open source way"