From: Aaron Bono <postgresql@aranya.com>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: Postgres <pgsql-admin@postgresql.org>
Subject: Re: System in Recovery Mode
Date: Mon, 25 Feb 2008 10:59:29 -0600
Message-ID: <bf05e51c0802250859q4cb471fcs345f1ba2640ed213@mail.gmail.com> (raw)
In-Reply-To: <1203958095.4252.79.camel@ebony.site>
References: <bf05e51c0802250611y401e1d1bs3cd4e789e917f9f1@mail.gmail.com>
<1203954173.4252.59.camel@ebony.site>
<bf05e51c0802250753y2c954789td495f30378a8e615@mail.gmail.com>
<1203958095.4252.79.camel@ebony.site>
On Mon, Feb 25, 2008 at 10:48 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> On Mon, 2008-02-25 at 09:53 -0600, Aaron Bono wrote:
>
> <2008-02-25 07:15:24 CST username 127.0.0.1>ERROR: unrecognized node
> type: 4260493
> >
>
> ...
>
> > <2008-02-25 07:15:49 CST username 127.0.0.1>CONTEXT: PL/pgSQL
> > function "get_branch_for_zip" line 61 at fetch
>
> ...
>
> > <2008-02-25 07:15:56 CST >LOG: could not truncate directory
> > "pg_multixact/members": apparent wraparound
>
> Some interesting failures there.
>
> Is this a modified Postgres server? Are you running externally supplied
> C language functions? Have you had hardware problems?
This is NOT a modified PostgreSQL server. We are not using any externally
supplied C language functions or modules. However, we did have to upgrade
from what CPanel put on the server (it used version 7.x) and I don't know
what CPanel has done.
We did have a hard drive problem (errors on the drive) in the past and they
had to swap out a drive. It is a RAID configuration so no backup/restore
was necessary. We do have intermittent problems with the server and believe
it is related to Postgres. Our SA assures us there are currently no system
errors or other indications of hard drive problems.
We want to do an upgrade but are apprehensive as this is a production
server. Is there a place we can go to to get a good idea of how to perform
an upgrade with as little interruption to service as possible?
Thanks,
Aaron
--
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.comhttp://codeelixir.com
==================================================================
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: postgresql@aranya.com, simon@2ndquadrant.com
Subject: Re: System in Recovery Mode
In-Reply-To: <bf05e51c0802250859q4cb471fcs345f1ba2640ed213@mail.gmail.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