Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id CCC859FB205 for ; Wed, 29 Nov 2006 11:50:24 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 27021-06 for ; Wed, 29 Nov 2006 11:50:07 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from galagonx.fixdial.interware.hu (galagonx.fixdial.interware.hu [195.70.45.31]) by postgresql.org (Postfix) with ESMTP id D54319FB1E6 for ; Wed, 29 Nov 2006 11:50:13 -0400 (AST) Received: from szballa-xp.intra ([172.20.80.67]) by galagonx.fixdial.interware.hu with esmtp (Exim 3.36 #1 (Debian)) id 1GpRhL-0001Gv-00 for ; Wed, 29 Nov 2006 16:50:11 +0100 Message-ID: <456DAC36.4080203@confinsystems.com> Date: Wed, 29 Nov 2006 16:50:14 +0100 From: Szabolcs BALLA User-Agent: Thunderbird 1.5.0.8 (Windows/20061025) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: dump from 8.x restore to 7.3.x References: <475722.43429.qm@web31810.mail.mud.yahoo.com> In-Reply-To: <475722.43429.qm@web31810.mail.mud.yahoo.com> X-Enigmail-Version: 0.94.0.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/237 X-Sequence-Number: 23764 Hi, I've already made almost same upgrade (7.4->8.1) under Debian linux. On Debian the 8.1 database structure will be installed into /var/lib/postgresql/ by default and on 7.4 it's /var/lib/postgres/. So if you remove the packages and you (or your package manager) do not remove the databases physically you only need to reinstall the old package (without owewrite the old sturcture, (move the directory to somewhere if you want to be sure)) and the fallback will fast and safe. Szabek