Hi,
I need to migrate some data (a few GB's) from an 8.4 database to an 8.3 database using pg_dump. What is the best way to acheive this?
E.g. Run pg_dump from the 8.3 host pointing it at the 8.4 host and include the version mismatch parameter?
Or, run pg_dump on the 8.4 host, then zip the 8.4 dump file, transfer it to the 8.3 host and run pg_restore from the 8.3 host - will I encounter version problems doing this?
Or any other methods that would be better suited?
TIA