From owner-freebsd-stable@FreeBSD.ORG  Thu Sep 23 09:02:49 2004
Return-Path: <owner-freebsd-stable@FreeBSD.ORG>
Delivered-To: freebsd-stable@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id EDDEB16A4CE
	for <freebsd-stable@freebsd.org>;
	Thu, 23 Sep 2004 09:02:49 +0000 (GMT)
Received: from pluto.dutchdsl.nl (pluto.dutchdsl.nl [62.221.254.25])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 890D343D2F
	for <freebsd-stable@freebsd.org>;
	Thu, 23 Sep 2004 09:02:49 +0000 (GMT)
	(envelope-from norman@webminded.nl)
Received: from [10.0.0.13] (dsl-82-199-142-179.dutchweb.nl [82.199.142.179])
	by pluto.dutchdsl.nl (Postfix) with ESMTP id 1B75340007A
	for <freebsd-stable@freebsd.org>;
	Thu, 23 Sep 2004 11:02:48 +0200 (CEST)
Message-ID: <4152913A.5080408@webminded.nl>
Date: Thu, 23 Sep 2004 11:02:50 +0200
From: Norman Uittenbogaart|Webminded <norman@webminded.nl>
Organization: Webminded
User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: freebsd-stable@freebsd.org
References: <20040909120120.30C1016A4D0@hub.freebsd.org>
In-Reply-To: <20040909120120.30C1016A4D0@hub.freebsd.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Subject: Postgres downgrade
X-BeenThere: freebsd-stable@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Production branch of FreeBSD source code
	<freebsd-stable.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>,
	<mailto:freebsd-stable-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-stable>
List-Post: <mailto:freebsd-stable@freebsd.org>
List-Help: <mailto:freebsd-stable-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>,
	<mailto:freebsd-stable-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 23 Sep 2004 09:02:50 -0000

I upgraded my postgres without dumping my data and reimport them, so now 
my database won t start,

> [root@cp root]# /usr/local/etc/rc.d/010.pgsql.sh start
> pgsqlFATAL: database files are incompatible with server
> DETAIL: The data directory was initialized by PostgreSQL version 7.3, which is not compatible with this version 7.4.2.

Now how can I downgrade from Postgres 7.4.2 back to Postgres 7.3 without 
loosing my data ?
Would a make install in /usr/ports/databases/postgresql73 be sufficient ?

Please help !!!


Norman Uittenbogaart