Re: Database recovery

You wrote:
> tony <tony(at)animaproductions(dot)com> writes:
> > Hi
> >
> > In the doc I have "this section needs to be written"
> >
> > I have a database system to recover any pointers greatly
> > appreciated. My tape backup is two weeks old... I know that is bad
> > but I have to live with it.
> Is it a backup of a dump file produced with pg_dump, or a backup of
> the raw database files?

Raw database

> What have you tried so far?

Nothing yet too scared to break it more. I'll check the developpement docs now.

Cheers

Tony
--
tony(at)animaproductions(dot)com

JWebMail WebMail/Java v0.7.6 WWW to Mail Gatewayy
>From pgsql-general-owner(at)postgresql(dot)org Tue Dec 25 07:12:02 2001
Received: from mail.animaproductions.com (mail.animaproductions.com [194.206.157.155])
by postgresql.org (8.11.3/8.11.4) with ESMTP id fBPC2Nm20737
for <pgsql-general(at)postgresql(dot)org>; Tue, 25 Dec 2001 07:02:23 -0500 (EST)
(envelope-from tony(at)animaproductions(dot)com)
Received: from worldcompany (localhost [127.0.0.1])
by mail.animaproductions.com (Postfix) with ESMTP
id B5C1797241; Tue, 25 Dec 2001 12:31:54 +0100 (CET)
Message-ID: <2750588(dot)1009279914712(dot)JavaMail(dot)root(at)localhost>
Date: Tue, 25 Dec 2001 12:31:54 +0100 (CET)
From: tony <tony(at)animaproductions(dot)com>
To: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
Subject: Re: Database recovery
Cc: pgsql-general(at)postgresql(dot)org
Mime-Version: 1.0
X-Mailer: WebMail/Java v0.7.6, SendMessage plugin v1.8
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset="utf-8"
X-Archive-Number: 200112/791
X-Sequence-Number: 18881

You wrote:
> > In the doc I have "this section needs to be written"
> Check the new development docs. There is some content now.
> > I have a database system to recover any pointers greatly appreciated. My tape
> >backup is two weeks old... I know that i s bad but I have to live with it.
> You will need to give some hints on what the symptoms are.

Hardware failure. postmaster refuses to start. I don't know if anybody was writing to the database at the time.

cheers

tony

--
tony(at)animaproductions(dot)com

JWebMail WebMail/Java v0.7.6 WWW to Mail Gatewaya
>From pgsql-general-owner(at)postgresql(dot)org Tue Dec 25 15:12:12 2001
Received: from moutvdom01.kundenserver.de (moutvdom01.kundenserver.de [195.20.224.200])
by postgresql.org (8.11.3/8.11.4) with ESMTP id fBPK3Lm38043
for <pgsql-general(at)postgresql(dot)org>; Tue, 25 Dec 2001 15:03:22 -0500 (EST)
(envelope-from poppcorn(at)cornelia-boenigk(dot)de)
Received: from [195.20.224.219] (helo=mrvdom03.kundenserver.de)
by moutvdom01.kundenserver.de with esmtp (Exim 2.12 #2)
id 16Ixn9-0001pc-00; Tue, 25 Dec 2001 21:03:15 +0100
Received: from bace2.pppool.de ([213.7.172.226] helo=zwerg98)
by mrvdom03.kundenserver.de with smtp (Exim 2.12 #2)
id 16Ixn8-0002IY-00; Tue, 25 Dec 2001 21:03:15 +0100
Message-ID: <002801c18d7f$3c5745c0$aec1fea9(at)zwerg98>
Reply-To: "Cornelia Boenigk" <c(at)cornelia-boenigk(dot)de>
From: "Cornelia Boenigk" <poppcorn(at)cornelia-boenigk(dot)de>
To: "Joe Conway" <joseph(dot)conway(at)home(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
References: <4365337(dot)1009182743929(dot)JavaMail(dot)root(at)localhost> <m3n108h7hw(dot)fsf(at)varsoon(dot)denali(dot)to> <004f01c18cdc$47eb9600$aec1fea9(at)zwerg98> <3C27DF28(dot)8020809(at)home(dot)com>
Subject: Re: Question about like
Date: Tue, 25 Dec 2001 20:37:03 +0100
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700
X-Archive-Number: 200112/792
X-Sequence-Number: 18882

Hi Joe

> but if "name" is
> a CHAR() field, you need to allow for the spaces padded to the
end

This was exactly the problem.
Thank you

Conni