From owner-freebsd-stable@FreeBSD.ORG  Thu Sep 23 20:35:59 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 6FB9016A4CE
	for <freebsd-stable@freebsd.org>;
	Thu, 23 Sep 2004 20:35:59 +0000 (GMT)
Received: from mproxy.gmail.com (rproxy.gmail.com [64.233.170.196])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 1928943D1F
	for <freebsd-stable@freebsd.org>;
	Thu, 23 Sep 2004 20:35:59 +0000 (GMT)
	(envelope-from swhetzel@gmail.com)
Received: by mproxy.gmail.com with SMTP id 79so2464501rnk
	for <freebsd-stable@freebsd.org>;
	Thu, 23 Sep 2004 13:34:40 -0700 (PDT)
Received: by 10.38.164.27 with SMTP id m27mr224578rne;
        Thu, 23 Sep 2004 13:33:04 -0700 (PDT)
Received: by 10.38.75.49 with HTTP; Thu, 23 Sep 2004 13:33:01 -0700 (PDT)
Message-ID: <790a9fff04092313334c105026@mail.gmail.com>
Date: Thu, 23 Sep 2004 15:33:01 -0500
From: Scot Hetzel <swhetzel@gmail.com>
To: Norman Uittenbogaart|Webminded <norman@webminded.nl>
In-Reply-To: <4152913A.5080408@webminded.nl>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
References: <20040909120120.30C1016A4D0@hub.freebsd.org>
	 <4152913A.5080408@webminded.nl>
cc: freebsd-stable@freebsd.org
Subject: Re: Postgres downgrade
X-BeenThere: freebsd-stable@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
Reply-To: Scot Hetzel <swhetzel@gmail.com>
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 20:35:59 -0000

On Thu, 23 Sep 2004 11:02:50 +0200, Norman Uittenbogaart|Webminded
<norman@webminded.nl> wrote:
> 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 ?
> 
First backup/export the database to a file, then uninstall Postgres
7.4.2, and install Postgres 7.3.

If the downgrade results in your database being unreadable to Postgres
7.3, then remove the database and use the backup to restore it.