X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 839CB9DC812 for ; Sun, 19 Mar 2006 08:48:33 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 08661-07 for ; Sun, 19 Mar 2006 08:48:36 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from uproxy.gmail.com (uproxy.gmail.com [66.249.92.193]) by postgresql.org (Postfix) with ESMTP id 45C0E9DC806 for ; Sun, 19 Mar 2006 08:48:31 -0400 (AST) Received: by uproxy.gmail.com with SMTP id m3so492428uge for ; Sun, 19 Mar 2006 04:48:34 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=QzFrzHNNJsbPTXwTuKi4xoX1r5pEAcQjm4RBbIhLhJpWD1h7ndnuS52EiiKGohGI/H6uQz7ZHgbW5obF3MaSi9tklmeodV+JHqLR5q2rscvdBmHoC0DphvBzmiY7bLMop7Rg+tMvFZTf63lOvhdylbB4vQPHS/+iYnQKVUyhyMw= Received: by 10.66.222.13 with SMTP id u13mr3438698ugg; Sun, 19 Mar 2006 04:48:34 -0800 (PST) Received: by 10.67.27.10 with HTTP; Sun, 19 Mar 2006 04:48:34 -0800 (PST) Message-ID: Date: Sun, 19 Mar 2006 12:48:34 +0000 From: "Guido Barosio" To: "Anton J. Garnik" Subject: Re: initdb creates a wrong-version database Cc: pgsql-admin@postgresql.org In-Reply-To: <239932927.20060318032058@irfc.ru> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <239932927.20060318032058@irfc.ru> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.21 required=5 tests=[AWL=0.210] X-Spam-Score: 0.21 X-Spam-Level: X-Archive-Number: 200603/155 X-Sequence-Number: 20912 Hi Anton, I guess that you are trying to initdb a location that was previously initdb'ed with the older version. Check if your $PGDATA contains information, and if you, consider to rename it or created a new $PGDATA to initdb. Regards, Guido. On 3/17/06, Anton J. Garnik wrote: > Hello pgsql-admin, > > I have installed PostgreSQL 8.1.3 on Trustix Secure Linux > When I have created the initial database with initdb > and run postmaster, it says: > --------------------------- > An old version of the database format was found.\nYou need to upgrade the= data format before using P > ostgreSQL.\nSee /usr/share/postgresql-package/README.rpm.dist for more in= formation. > --------------------------- > > What is wrong? In the README I found no information about how to > convert database format, just about migration data > > There was postgresql 7.4 libs in my /usr/lib directory (it is needed by > php4), but no conflicts with names. > > -- > Best regards, > Anton mailto:valinor@irfc.ru > > Ekaterinburg, Russia > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > -- Guido Barosio -----------------------