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

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

on 9/13/03 10:14 PM, Phil Beynon at phil@xxxxxxxxxxxxxxxxxxxxxxxxx wrote:

>> 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
Phil,

That sounds like a good idea. Where are the Postgresql data files stored? I
take it I can just copy the data files to another directory, and then copy
them back after I've re-installed PostgreSQL?

Thanks,
Jim

-- 
My recommended eBook: 'Accessible Web Typography - an introduction for web
designers' at http://www.scotconnect.com/webtype.php


Pat's Guide to Glasgow West End: http://www.glasgowwestend.co.uk
Flathunting: http://www.glasgowwestend.co.uk/flathunting/