Re: [cobalt-users] Need fix for raq3 PostgreSQL - "backend closed the channel unexpectedly"

["Jim Byrne (NTL)" <james.byrne2@xxxxxxxxxxxx>]

on 9/14/03 5:05 AM, Ken Marcus -Precision Web Hosting at
ken@xxxxxxxxxxxxxxxx wrote:

> 
> ----- Original Message -----
> From: "Jim Byrne (NTL)" <james.byrne2@xxxxxxxxxxxx>
> To: <cobalt-users@xxxxxxxxxxxxxxx>
> Sent: Saturday, September 13, 2003 4:32 AM
> Subject: [cobalt-users] Need fix for raq3 PostgreSQL - "backend closed the
> channel unexpectedly"
> 
> 
>> Hi,
>> 
>> I have a raq3 but I have no users or sites showing in my GUI. I tried to
> fix
>> with the meta-verify tool - but there seems to be a problem with the
>> database itself not just the data; I get the error,
>> 
>> "backend closed the channel unexpectedly. This probably means the backend
>> terminated abnormally before or while processing the request."
>> 
>> I don't want to have to do a full restore of the raq, because it turns out
>> that the backup service I use backs up the preferences from the GUI
> database
>> (and the database is screwed - so no prefs are backed up).
>> 
>> Does anyone have any idea how to fix this problem? If it means
> re-installing
>> PostgreSQL I am willing to do that - thought some instruction on how to do
>> it would be useful.
>> 
>> Thanks,
>> Jim
>> 
>> 
> Jim,
> 
> If it was me I'd try the steps at the url below (for a raq4)
> http://list.cobalt.com/pipermail/cobalt-users/2003-June/093094.html
> 
> Basically, get rid of the corrupted database, re-initialize it, then use
> meta-verify to add the data to it.
> 
> If the steps don't work, it's easy to just copy the directory back from
> where you moved it to.
> 
>>> 
> For a raq4, if you follow the steps below it will fix it easily in 10
> minutes, they are from:
> http://list.cobalt.com/pipermail/cobalt-users/2002-January/062036.html
> 
> su root
> mkdir /var/lib/pgsql/dataold
> mv /var/lib/pgsql/data  /var/lib/pgsql/dataold
> mkdir /var/lib/pgsql/data
> chown postgres:postgres /var/lib/pgsql/data
> chmod 700 /var/lib/pgsql/data
> su postgres
> initdb -D /var/lib/pgsql/data
> su
> /etc/rc.d/init.d/postgresql stop
> /etc/rc.d/init.d/postgresql start
> cd /usr/local/sbin       (or wherever the meta-verify i son a raq 3)
> ./meta-verify -si
> Answer yes to all questions   uppercase Y
> ./meta-verify -sa
> Answer yes to all questions
> ./meta-verify -ui
> Answer yes to all questions
> #./meta-verify -ua
> Answer yes to all questions
> /usr/local/sbin/swatch
> <<
> 
> 
> Ken Marcus

Marcus,

I substituted the data director on my raq3 for the one in the above
instructions - and I get as far as the meta-verify lines. I then get the
error:

"Can't call method "exec" on an undefined value at
/usr/lib/perl5/site_perl/5.005/Cobalt/Meta.pm line 1056."

So that is not looking good.

Thinking that I would try to re-install PostgreSQL database with the rpms -
linbks to which I had previously found on this list:

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

But - unfortunately they no longer exist at these addresses. :-(

Does anyone know where I can find these particular versions of the
PostgreSQl rpms - as these seem to be the one's related to setting up the
correct tables for the cobalt raq3?

I did look to see if the cobalt tables existed in the database - after
carrying out the above steps - but they don't.

Any help would be appreciated.

Thanks,
Jim