pg_dump from 8.4 to 8.3

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux