RE: [cobalt-users] Need fix for raq3 PostgreSQL - "backend closedthe channel unexpectedly"

["Phil Beynon" <phil@xxxxxxxxxxxxxxxxxxxxxxxxx>]

> on 9/13/03 10:28 PM, Gerald Waugh at gwaugh@xxxxxxxxxxxxxxxxxxxxxxx wrote:
>
> > On Sat, 13 Sep 2003, Jim Byrne (NTL) wrote:
> >>
> >> Is this the way to re-install the broken Posgresql on my raq3?
> >> Download,
> >>
> 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. I
>> will 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 that sound as if it will work?
>
> You will loose what is left of your database.
> Are you sure you can't dump the database and inspect it, maybe
> correct errors?
>
> Gerald
Gerald,

I can't dump the database, because it is not possible to give it any
commands - it just gives the same error no matter what command I try.

Thanks,
Jim
--

Jim,
Regardless of what the database program is doing can you not back up the
data files, then get the database application restored to working then put
the data files back?
If it's the Postgresql that is broken it could be the data is in fact intact
and reusable.

Phil


** http://www.diygear.com THE Online DIY Toolstore For DIY & Business
** Infolink Electronic Systems Ltd. http://www.infolinkelectronics.co.uk
** Professional Web Design & Cobalt Hosting Solutions
** Sun Cobalt iForce Reseller - Canon Silver Reseller
** Contact: Sales@xxxxxxxxxxxxxxxxxxxxxxxxx
** Tel / Fax 0121 458 4894 (office) 0121 441 3558 (home)