X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 7D7DD4764B5 for ; Wed, 7 May 2003 11:56:18 -0400 (EDT) Received: from mail01.techtelnet.net (unknown [200.69.128.98]) by postgresql.org (Postfix) with ESMTP id CAE1A47648D for ; Wed, 7 May 2003 11:56:16 -0400 (EDT) Received: (qmail 30288 invoked from network); 7 May 2003 15:56:09 -0000 Received: from unknown (HELO localhost) ([192.168.200.58]) (envelope-sender ) by mail (qmail-ldap-1.03) with SMTP for ; 7 May 2003 15:56:09 -0000 Received: from ADSL142-179.advancedsl.com.ar (ADSL142-179.advancedsl.com.ar [200.63.142.179]) by keko.techtelnet.com (IMP) with HTTP for ; Wed, 7 May 2003 12:56:09 -0300 Message-ID: <1052322969.3eb92c997f6de@keko.techtelnet.com> Date: Wed, 7 May 2003 12:56:09 -0300 From: mdc@keko.com.ar To: pgsql-sql@postgresql.org Subject: help database corruption MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 User-Agent: Internet Messaging Program (IMP) 3.2.1 X-Originating-IP: 200.63.142.179 Content-Transfer-Encoding: quoted-printable X-Spam-Status: No, hits=-2.1 required=5.0 tests=BAYES_10,MSG_ID_ADDED_BY_MTA_3,NO_REAL_NAME, RCVD_IN_OSIRUSOFT_COM,RCVD_IN_SBL,SATISFACTION, USER_AGENT_IMP version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/133 X-Sequence-Number: 13298 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 fiche= ro o el directorio vacuumdb: vacuum EstacionVasconiaDevelop failed [postgres@defiant postgres]$ backend messages XLogFlush: request 0/109118E8 is not satisfied --- flushed only to 0/108EA= 9D8 ERROR: _mdfd_getrelnfd: cannot open relation tmpturnos: No existe el fiche= ro o=20 el directorio ERROR: _mdfd_getrelnfd: cannot open relation tmpturnos: No existe el fiche= ro 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