X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id A455E4763D5
	for <pgsql-sql@postgresql.org>; Wed,  7 May 2003 23:57:15 -0400 (EDT)
Received: from mta5.snet.net (mta5.snet.net [204.60.203.77])
	by postgresql.org (Postfix) with ESMTP id BF9D8475B8E
	for <pgsql-sql@postgresql.org>; Wed,  7 May 2003 23:57:14 -0400 (EDT)
Received: from pop.snet.net (pop.snet.net [204.60.203.72])
	by mta5.snet.net (8.12.3/8.12.3/SNET-mx-1.2/D-1.1.1.1/O-1.1.1.1) with
	ESMTP id h47IdSB8024772; Wed, 7 May 2003 14:39:29 -0400 (EDT)
X-Originating-IP: [64.252.95.167]
X-SBCIS-MTA: [pop.snet.net]
Received: from kencast.com (167.95.252.64.snet.net [64.252.95.167])
	by pop.snet.net (8.12.3/8.12.3/SNET-pop-1.2/D-1.1.1.1/O-1.1.1.1) with
	ESMTP id h47IdMW7002461; Wed, 7 May 2003 14:39:22 -0400 (EDT)
Message-ID: <3EB9570A.6090202@kencast.com>
Date: Wed, 07 May 2003 14:57:14 -0400
From: Wei Weng <wweng@kencast.com>
User-Agent: Mozilla/5.0 (Windows; U; WinNT4.0; en-US; rv:1.3) Gecko/20030312
X-Accept-Language: en-us, en, zh-cn
MIME-Version: 1.0
To: mdc@keko.com.ar
Cc: pgsql-sql@postgresql.org
Subject: Re: help database corruption
References: <1052322969.3eb92c997f6de@keko.techtelnet.com>
In-Reply-To: <1052322969.3eb92c997f6de@keko.techtelnet.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
X-Spam-Status: No, hits=-34.9 required=5.0
	tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,REFERENCES,
	REPLY_WITH_QUOTES,SATISFACTION,USER_AGENT_MOZILLA_UA
	autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200305/152
X-Sequence-Number: 13317

Sorry I couldn't help you with the problem, but I have been pondering=20
this question for a while.

How do you get the "backend messages"? Do they get logged somewhere? How=20
do you turn them on?

Thanks.
Wei

mdc@keko.com.ar wrote:

>hi guys
>
> the database seems to corrupt .
> the messages are
>intent to vacumm:
>
>[postgres@defiant postgres]$ /usr/local/pgsql/bin/vacuumdb -a
>Vacuuming EstacionVasconiaDevelop
>ERROR:  _mdfd_getrelnfd: cannot open relation tmpturnos: No existe el fich=
ero o
>el directorio
>vacuumdb: vacuum  EstacionVasconiaDevelop failed
>[postgres@defiant postgres]$
>
>
>backend messages
>
> XLogFlush: request 0/109118E8 is not satisfied --- flushed only to 0/108E=
A9D8
>ERROR:  _mdfd_getrelnfd: cannot open relation tmpturnos: No existe el fich=
ero o=20
>el directorio
>ERROR:  _mdfd_getrelnfd: cannot open relation tmpturnos: No existe el fich=
ero o=20
>el directorio
>
>
>explanation:
>
> the applicatoin create the tmpturnos with
>
>  select into tmpturnos from ....
>
> the table tmpturnos does not exist for database=20
> if you try=20
>
> create tmpturnos(...)
>  refuse with databse already exists
> if try
>  drop table tmpturnos=20
>  refuse with=20
>   database tmpturnos not exists
>
> any ideas ?
>=20
>  technical information
>
>   linux mandrake 8.0
>    postgres version 7.3.1
>
> best regards=20
> MDc
>
>=20=20
>
>
>-------------------------------------------------
>=BFTodav=EDa no naveg=E1s con Keko?
>Hac=E9 click aqu=ED: http://www.keko.com.ar
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly
>
>
>
>
>=20=20
>