Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 23 Sep 2004 11:02:50 +0200
From:      Norman Uittenbogaart|Webminded <norman@webminded.nl>
To:        freebsd-stable@freebsd.org
Subject:   Postgres downgrade
Message-ID:  <4152913A.5080408@webminded.nl>
In-Reply-To: <20040909120120.30C1016A4D0@hub.freebsd.org>
References:  <20040909120120.30C1016A4D0@hub.freebsd.org>

next in thread | previous in thread | raw e-mail | index | archive | help
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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4152913A.5080408>