X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id F417F476141 for ; Wed, 7 May 2003 14:12:50 -0400 (EDT) Received: from mail01.techtelnet.net (unknown [200.69.128.98]) by postgresql.org (Postfix) with ESMTP id 4B577475CE5 for ; Wed, 7 May 2003 14:12:49 -0400 (EDT) Received: (qmail 29131 invoked from network); 7 May 2003 18:12:48 -0000 Received: from unknown (HELO localhost) ([192.168.200.58]) (envelope-sender ) by mail (qmail-ldap-1.03) with SMTP for ; 7 May 2003 18:12:48 -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 15:12:48 -0300 Message-ID: <1052331168.3eb94ca086b4e@keko.techtelnet.com> Date: Wed, 7 May 2003 15:12:48 -0300 From: mdc@keko.com.ar To: "pgsql-sql@postgresql.org" Cc: mdc_marcelo@yahoo.com 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=-1.7 required=5.0 tests=BAYES_10,MSG_ID_ADDED_BY_MTA_3,NO_REAL_NAME, RCVD_IN_OSIRUSOFT_COM,RCVD_IN_SBL,SATISFACTION, TO_ADDRESS_EQ_REAL,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/144 X-Sequence-Number: 13309 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