Re: [GENERAL] error migrating database from 8.4 to 8.3

2010-02-11 Thread Scott Ribe
> Export/import is the only option. Or upgrade PostgreSQL to 8.4 on the downgraded server. -- Scott Ribe scott_r...@killerbytes.com http://www.killerbytes.com/ (303) 722-0567 voice -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: htt

Re: [GENERAL] error migrating database from 8.4 to 8.3

2010-02-11 Thread Andrej
On 9 February 2010 02:55, Marc Lustig wrote: > Due to a server issue we needed a reinstallation of Ubuntu along with a > downgrade to Ubuntu Hardy. > > > So this is what we did: > > - copied all from /var/lib/postgresql/8.4/main/ to the new server > /var/lib/postgresql/8.3/main/ > - edited /var/

Re: [GENERAL] error migrating database from 8.4 to 8.3

2010-02-11 Thread Filip RembiaƂkowski
2010/2/8 Marc Lustig > Due to a server issue we needed a reinstallation of Ubuntu along with a > downgrade to Ubuntu Hardy. > > > So this is what we did: > > - copied all from /var/lib/postgresql/8.4/main/ to the new server > /var/lib/postgresql/8.3/main/ > - edited /var/lib/postgresql/8.3/main/p

[GENERAL] error migrating database from 8.4 to 8.3

2010-02-11 Thread Marc Lustig
Due to a server issue we needed a reinstallation of Ubuntu along with a downgrade to Ubuntu Hardy. So this is what we did: - copied all from /var/lib/postgresql/8.4/main/ to the new server /var/lib/postgresql/8.3/main/ - edited /var/lib/postgresql/8.3/main/postmaster.opts to correct the path