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
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.
Would I not lose all my settings / users when deinstalling ? Norman Uittenbogaart Ari Suutari wrote, On 23-9-2004 11:24:> 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. > > _______________________________________________ > freebsd-stable@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-stable > To unsubscribe, send any mail to "freebsd-stable-unsubscribe@freebsd.org"
On Thu, 23 Sep 2004 11:48+0200, Norman Uittenbogaart wrote:> Would I not lose all my settings / users when deinstalling ?Assuming you are able to use the old pg_dumpall to get hold of everything in your database cluster(s), you should retain everything when you restore the database cluster(s). Wish you best of luck! -- ---------------------------------------------------------------------- Trond Endrest?l | trond@ramstind.gtf.ol.no Patron of The Art of Computer Programming| FreeBSD 4.8-S & Pine 4.55
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.