[GENERAL] migrating data from 8.4 to 8.3

Hi, can we safely put the data from /var/lib/postgresql/8.4/main/ of server x to /var/lib/postgresql/8.3/main/ of server y, considering that the new target machine is running 8.3 whereas the old one ran 8.4 ? Rgards Marc -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To m

[GENERAL] recovering fs-data from previous installation

I managed to install again postgresql-8.4 from hardy-backports. Now the installation is identical with the previous one. With the fresh database, the server starts up fine. Now I copied all from the backup to /usr/lib/postgresql/8.4 /var/lib/postgresql/8.4 The the startup fails like this: * S

[GENERAL] migrating data from 8.4 to 8.3

Hi, can we safely put the data from /var/lib/postgresql/8.4/main/ of server x to /var/lib/postgresql/8.3/main/ of server y, considering that the new target machine is running 8.3 whereas the old one ran 8.4 ? Rgards Marc -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To m

[GENERAL] error migrating database from 8.4 to 8.3

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