Postgresql 'backend closed the channelunexpectedly' - how to re-install?

From: "Jim Byrne (NTL)" <james(dot)byrne2(at)ntlworld(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Postgresql 'backend closed the channelunexpectedly' - how to re-install?
Date: 2003-09-13 20:12:23
Message-ID: BB8938B7.8D29%james.byrne2@ntlworld.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I have a raq3 - which uses postgresql to hold the information for the web
prefs GUI - but the database now seems to be corrupted; I have no user or
site data in my browser GUI.

I tried running meta-verify-raq3 for fixing a broken GUI, but the database
does not seem to be capable of processing any commands. Among other things,
it gives me the following feedback:

"checking system+database coherency...
META getall - FAIL: pqReadData() -- backend closed the channel
unexpectedly. This probably means the backend terminated
abnormally before or while processing the request.
database | 0
system | 61
total | 61
valid | 0
invalid | 61

verifying 0 VALID user(s)..."

I had a look at the database but although I can login, all commands give the
same error message about the 'backend closing the channel' unexpectedly. It
looks like the database itself is corrupted, and not just the data."

I have spent a lot of time looking for fixes to this problem - without
success. It looks to me as if I need to re-install the database?

Would the following be the way to do it:

Download the following onto the raq3,

ftp://ftp.cobaltnet.com/pub/products/raq3/RPMS/postgresql-devel-6.5.2-C2.i38
6.rpm

and

ftp://ftp.cobaltnet.com/pub/products/raq3/RPMS/postgresql-6.5.2-C2.i386.rpm

delete the existing PostgreSQl and install it using the above rpms. Then use
the meta-verify to populate the database with the prefs?

I will have to assume that the rpms will install in the correct
directory and that no other settings are required.

Does anyone on the list have experience of installing the Posgresql database
on a raq3 - do the above sound as if it would work?

Thanks,
Jim

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-09-13 23:21:58 Re: Postgresql 'backend closed the channelunexpectedly' - how to re-install?
Previous Message Vajda Gabor 2003-09-13 20:10:11 Re: Concatenating string fields with GROUP BY clause