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

["Ken Marcus -Precision Web Hosting" <ken@xxxxxxxxxxxxxxxx>]

----- 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
Precision Web Hosting
ken@xxxxxxxxxxxxxxxx
www.precisionweb.net