Re: Help - corruption issue?

From: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Help - corruption issue?
Date: 2011-04-20 10:56:01
Message-ID: BANLkTiku1TGarjXbVOgfpe3ygsnq4akD2A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On a fast network it should only take a few minutes.  Now rsyncing
> live 2.4 TB databases, that takes time. :)  Your raptors, if they're
> working properly, should be able to transfer at around 80 to
> 100Megabytes a second.  10 to 15 seconds a gig.  30 minutes or so via
> gig ethernet.  I'd run iostat and see how well my drive array was
> performing during a large, largely sequential copy.

OK. An update.

We have changed all the hardware except disks.

REINDEX still gave this problem:

--
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
--

So I rebooted and logged back in a single user mode. All services
stopped. All networking stopped. Only postgresql started. I tried the
REINDEX again.

Same problem :(

This means the problem is likely with data?

I do have a "pg_dumpall" dump from 1 day before. Will lose some data,
but should have most of it.

Is it worth it for me to try and restore from there? What's the best
thing to do right now?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jasen Betts 2011-04-20 13:00:03 Re: Auto Adjust Age
Previous Message Tore Halvorsen 2011-04-20 10:28:24 Re: Using column aliasses in the same query