From: Chris Hoover <revoohc@sermonaudio.com>
To: Vishal Kashyap @ [SaiHertz] <vishalonlist@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: URGENT - HELP WITH 7.3.4 Strangeness
Date: Mon, 22 Nov 2004 16:03:11 -0500
Message-ID: <41A2540F.2060402@sermonaudio.com> (raw)
In-Reply-To: <77b69d2104112212087dacd577@mail.gmail.com>
References: <41A2347F.8030606@sermonaudio.com>
<77b69d2104112212087dacd577@mail.gmail.com>
Actually,
We have 3 distinct db servers, each with separate db's on them. There
are between 20 and 170 db's per server.
I actually moved a db from db server 3 to the new db server and it
worked fine on the new db server. However, when we went to move it back
to either db server 2 or 3, the problem reappeared??? I think since it
worked fine on the move to the new db server, it eliminates corrupt data.
Is there a good way to test for a memory issue w/o bringing the servers
down? Of course, the db servers are all production, so we don't have
large windows to work with.
Thanks,
chris
Vishal Kashyap @ [SaiHertz] wrote:
>Chris ,
>
>
>
>
>>Here is what is happening:
>>
>>1. Last Sunday, ran a reindex on all databases across our 3 postgresql
>>servers. This was done using the reindexdb script from the contrib
>>directory. The reindex was prompted due to strangeness on db server 1.
>>
>>
>
>>From going through the full text I understand that db server 1
>database is on all the other server.
>Now if this is true then db server 1 has some kinda Hardware issues.
>Which leads to database corruption and same data was loaded on other
>servers.
>check end posts of this thread
>http://archives.postgresql.org/pgsql-general/2003-11/msg01511.php
>
>
>
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: revoohc@sermonaudio.com, vishalonlist@gmail.com
Subject: Re: URGENT - HELP WITH 7.3.4 Strangeness
In-Reply-To: <41A2540F.2060402@sermonaudio.com>
References: <41A2347F.8030606@sermonaudio.com> <77b69d2104112212087dacd577@mail.gmail.com> <41A2540F.2060402@sermonaudio.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox