From owner-freebsd-stable@FreeBSD.ORG  Thu Sep 23 09:24:35 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 0599716A4CE
	for <freebsd-stable@freebsd.org>;
	Thu, 23 Sep 2004 09:24:35 +0000 (GMT)
Received: from poison2.syncrontech.com (adsl-nat.syncrontech.com
	[213.28.98.3])	by mx1.FreeBSD.org (Postfix) with ESMTP id 47EBE43D49
	for <freebsd-stable@freebsd.org>;
	Thu, 23 Sep 2004 09:24:33 +0000 (GMT)
	(envelope-from ari@suutari.iki.fi)
Received: from guinness.syncrontech.com (guinness.syncrontech.com
	[62.71.8.19])i8N9OTPV046814;	Thu, 23 Sep 2004 12:24:30 +0300 (EEST)
	(envelope-from ari@suutari.iki.fi)
Received: from coffee (coffee.syncrontech.com [62.71.8.37])
	i8N9OTYY038124;	Thu, 23 Sep 2004 12:24:29 +0300 (EEST)
	(envelope-from ari@suutari.iki.fi)
Message-ID: <00ac01c4a14f$20c869b0$2508473e@sad.syncrontech.com>
From: "Ari Suutari" <ari@suutari.iki.fi>
To: "Norman Uittenbogaart|Webminded" <norman@webminded.nl>,
	<freebsd-stable@freebsd.org>
References: <20040909120120.30C1016A4D0@hub.freebsd.org>
	<4152913A.5080408@webminded.nl>
Date: Thu, 23 Sep 2004 12:24:29 +0300
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
Subject: Re: 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:24:35 -0000

Hi,

>> 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 ?

    I would try that (after deinstalling 7.4 first). Maybe it would be a 
good idea
    to copy the contents of /usr/local/pgsql/data directory to someplace 
safe, just
    in case something goes wrong.

        Ari S.