X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 805A23A3B8C for ; Mon, 13 Dec 2004 09:48:33 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 41906-05 for ; Mon, 13 Dec 2004 09:48:21 +0000 (GMT) Received: from ns1.turtle-entertainment.de (ns1.turtle-entertainment.de [193.41.200.20]) by svr1.postgresql.org (Postfix) with ESMTP id E728C3A5FB4 for ; Mon, 13 Dec 2004 09:48:21 +0000 (GMT) Received: from ip96.85.1311c-cud12k-02.ish.de ([62.143.85.96] helo=mail.office.turtle-entertainment.de) by ns1.turtle-entertainment.de with asmtp (Exim 3.22 #3 (Debian)) id 1CdmoQ-0006hY-00; Mon, 13 Dec 2004 10:48:14 +0100 Received: from ip19.1.1411j-cud12k-02.ish.de ([62.143.1.19] helo=[192.168.100.5]) by mail.office.turtle-entertainment.de with asmtp (Exim 3.22 #7 (Debian)) id 1CdmoO-0000Ny-00; Mon, 13 Dec 2004 10:48:12 +0100 Message-ID: <41BD6512.1080009@turtle-entertainment.de> Date: Mon, 13 Dec 2004 10:46:58 +0100 From: Bjoern Metzdorf User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Paulo Jobim Cc: pgsql-admin@postgresql.org Subject: Re: HELP database files are incompatible with server References: <7634F0BA-4C5C-11D9-805C-000A959E0542@terra.com.br> In-Reply-To: <7634F0BA-4C5C-11D9-805C-000A959E0542@terra.com.br> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.88 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, RCVD_IN_NJABL_DUL, RCVD_IN_SORBS_DUL X-Spam-Level: * X-Archive-Number: 200412/111 X-Sequence-Number: 15697 Seems you have broken your database files. You could try resetting PG_VERSION with pg_resetxlog or recompile postgres (I had a similar case where just recompiling worked). Make sure to take backups of $PGDATA before you try anything. Regards, Bjoern Paulo Jobim wrote: > Hi > I am posting again > I did a very small but terrible mistake with my database. > I installed postgresql and DSpace for use in the INSTITUTO ANTONIO > CARLOS JOBIM, dedicated to the work of this famous Brasilian composer. > I first installed a version 8.0beta5 of postgres but a software advisor > asked me to use a formal release and I installed version 7.4 and begin > to work with DSpace. After having submited about 200 items to DSpace a > researcher at the institute and myself found a bug when brousing the > archives. the log complained of a variable *XactIsoLevel. *and I learned > now it may be related to the JDBC driver. > Now comes the big mistake. I tryed to start the 8beta version of > postgres in a folder named /usr/local/pgsql2. it did not workand I > noticed postgres was trying to access the folder /usr/local/pgsqlwith > the 7.4version installed.after that I renamed pgsql as pgsqlbk and > renamed pgsql2 as pgsql and started the new version without a problem. I > noticed DSpace had still the same problem when brousing. (note that this > version of the database is empty) then I renamed the folders for the > original names, with pgsql containing the 7.4 database with all the > records for DSpace. but it never started again. it gives me the > following error: > > > FATAL: database files are incompatible with server > DETAIL: The database cluster was initialized with PG_CONTROL_VERSION 74, > but the server was compiled with PG_CONTROL_VERSION 72. > HINT: It looks like you need to initdb. > > is there a way to recover the database? > thank you for any help > Paulo Jobim