For starters a little more detail would be helpful, for example:
What version of PostgreSQL? What OS? What compiler? What happened that
caused this? Server Crash?
Matthew
Cott Lang wrote:
Sep 24 10:22:37 snafu postgres[18306]: [2-1] LOG: database system was
interrupted while in recovery at 200
Cott Lang wrote:
I wish I knew - this is what appeared to start it:
Sep 24 10:19:41 snafu postgres[18176]: [464-1] ERROR: could not open
segment 1 of relation "idx_ordl_id" (target block 1719234412): No such
file or
Sep 24 10:19:41 snafu postgres[18176]: [464-2] directory
I can't figure out what
Does pgfsck work on 7.4.x?
>
> Otherwise, maybe something here will help:
> http://svana.org/kleptog/pgsql/pgfsck.html
>
> ---(end of broadcast)---
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining colum
On Fri, 2004-09-24 at 11:43, Tom Lane wrote:
>
> I think your only chance is pg_resetxlog. Be aware that you won't
> necessarily have a consistent database afterwards --- in particular,
> whichever index that failure is about is certainly broken. I'd
> recommend a dump and reload, plus as much m
Cott Lang <[EMAIL PROTECTED]> writes:
> Sep 24 10:22:37 snafu postgres[18306]: [2-1] LOG: database system was
> interrupted while in recovery at 2004-09-24 10:21:41 MST
> Sep 24 10:22:37 snafu postgres[18306]: [2-2] HINT: This probably means
> that some data is corrupted and you will have to use
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Cott Lang
> Sent: Friday, September 24, 2004 10:21 AM
> To: [EMAIL PROTECTED]
> Subject: [HACKERS] CRITICAL HELP NEEDED! DEAD DB!
>
>
> Sep 24 10:22:37 snafu postgres[1
Sep 24 10:22:37 snafu postgres[18306]: [2-1] LOG: database system was
interrupted while in recovery at 2004-09-24 10:21:41 MST
Sep 24 10:22:37 snafu postgres[18306]: [2-2] HINT: This probably means
that some data is corrupted and you will have to use the last backup for
recovery.
Sep 24 10:22:37
