Date: Thu, 23 Sep 2004 15:33:01 -0500 From: Scot Hetzel <swhetzel@gmail.com> To: Norman Uittenbogaart|Webminded <norman@webminded.nl> Cc: freebsd-stable@freebsd.org Subject: Re: Postgres downgrade Message-ID: <790a9fff04092313334c105026@mail.gmail.com> In-Reply-To: <4152913A.5080408@webminded.nl> References: <20040909120120.30C1016A4D0@hub.freebsd.org> <4152913A.5080408@webminded.nl>
next in thread | previous in thread | raw e-mail | index | archive | help
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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?790a9fff04092313334c105026>