From jkanter@virginia.edu Wed Nov 17 17:10:20 2004 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 AA0C33A4254 for ; Wed, 17 Nov 2004 17:10:20 +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 43111-06 for ; Wed, 17 Nov 2004 17:10:10 +0000 (GMT) Received: from fork6.mail.virginia.edu (fork6.mail.Virginia.EDU [128.143.2.176]) by svr1.postgresql.org (Postfix) with ESMTP id 7FF2B3A42BA for ; Wed, 17 Nov 2004 17:10:07 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by fork6.mail.virginia.edu (Postfix) with ESMTP id 551101C1C0 for ; Wed, 17 Nov 2004 12:10:06 -0500 (EST) Received: from fork6.mail.virginia.edu ([127.0.0.1]) by localhost (fork6.mail.virginia.edu [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 11880-06 for ; Wed, 17 Nov 2004 12:10:06 -0500 (EST) Received: from virginia.edu (d-137-133-131.bootp.Virginia.EDU [137.54.133.131]) by fork6.mail.virginia.edu (Postfix) with ESMTP id 110521C148 for ; Wed, 17 Nov 2004 12:10:06 -0500 (EST) Message-ID: <419B85E8.4080900@virginia.edu> Date: Wed, 17 Nov 2004 12:10:00 -0500 From: Jodi Kanter User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Postgres Admin List Subject: error on start Content-Type: multipart/alternative; boundary="------------040608010106070800070002" X-UVA-Virus-Scanned: by amavisd-new at fork6.mail.virginia.edu X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.0 tagged_above=0.0 required=5.0 tests=HTML_40_50, HTML_MESSAGE, HTML_TITLE_EMPTY X-Spam-Level: * X-Archive-Number: 200411/148 X-Sequence-Number: 15532 This is a multi-part message in MIME format. --------------040608010106070800070002 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Our Linux admin just upgraded our server to fedora Core 2 which apparently upgraded postgres to version 7.4.2-1 Now on trying to start the postgres server we get the following error: An old version of the database format was found.\nYou need to upgrade the data format before using PostgreSQL.\nSee (Your System's documentation directory)/postgresql-7.4/README.rpm-dist for more information. Can someone give me some insight into this please? The database was not touched. Should it have been dumped and restored in upgrading from 7.3.4? thanks Jodi -- _______________________________ Jodi L Kanter BioInformatics Database Administrator University of Virginia (434) 924-2846 jkanter@virginia.edu --------------040608010106070800070002 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit
Our Linux admin just upgraded our server to fedora Core 2 which apparently upgraded postgres to version 7.4.2-1
Now on trying to start the postgres server we get the following error:
An old version of the database format was found.\nYou need to upgrade the
data format before using PostgreSQL.\nSee (Your System's documentation
directory)/postgresql-7.4/README.rpm-dist for more information.

Can someone give me some insight into this please? The database was not touched. Should it have been dumped and restored in upgrading from 7.3.4?

thanks
Jodi
--
_______________________________

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu

 

--------------040608010106070800070002-- From devrim@gunduz.org Wed Nov 17 17:14:00 2004 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 043AC3A4208 for ; Wed, 17 Nov 2004 17:14:00 +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 43301-06 for ; Wed, 17 Nov 2004 17:13:57 +0000 (GMT) Received: from emo.org.tr (emo.org.tr [195.142.105.9]) by svr1.postgresql.org (Postfix) with ESMTP id 159F93A41B1 for ; Wed, 17 Nov 2004 17:13:57 +0000 (GMT) Received: by emo.org.tr (Postfix, from userid 41643) id 491DB2FDAD; Wed, 17 Nov 2004 19:13:48 +0200 (EET) Received: from localhost (localhost [127.0.0.1]) by emo.org.tr (Postfix) with ESMTP id 32BBC1121A0; Wed, 17 Nov 2004 19:13:48 +0200 (EET) Date: Wed, 17 Nov 2004 19:13:46 +0200 (EET) From: Devrim GUNDUZ X-X-Sender: devrim2@emo.org.tr To: Jodi Kanter Cc: Postgres Admin List Subject: Re: error on start In-Reply-To: <419B85E8.4080900@virginia.edu> Message-ID: References: <419B85E8.4080900@virginia.edu> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/149 X-Sequence-Number: 15533 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, On Wed, 17 Nov 2004, Jodi Kanter wrote: > Our Linux admin just upgraded our server to fedora Core 2 which apparently > upgraded postgres to version 7.4.2-1 > > Now on trying to start the postgres server we get the following error: > > An old version of the database format was found.\nYou need to upgrade the > data format before using PostgreSQL.\nSee (Your System's documentation > directory)/postgresql-7.4/README.rpm-dist for more information. > > Can someone give me some insight into this please? The database was not > touched. Should it have been dumped and restored in upgrading from 7.3.4? Yes. See: http://developer.postgresql.org/docs/postgres/install-upgrading.html - -- Devrim GUNDUZ devrim~gunduz.org devrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFBm4bMtl86P3SPfQ4RAo3gAKDR+HeMOK/43NXKHC0bNT5URYyFWQCg6dH5 +eoFIx0rVEFUjwUrfEsqAAs= =qP1r -----END PGP SIGNATURE-----