Il 21/02/2017 15:38, Melvin Davidson ha
scritto:
AFAIK pg_dump is version-independent (I use it to upgrade some small clusters), given that you are using the one from the newest version and you are dumping from old and restoring from new. Another thing that I saw is that pg_dump is less I/O stressful (I can almost safely dump databases from my production server in traffic hours, even if I never tried doing it in rush hours :-) ) and therefore slower than COPY, but on the other side, using COPY, the risk is to have all I/O bandwidth eaten by data transfer, especially if the amount of data to be transferred is considerable. I tried some times to COPY across different clusters with different versions, but I always had issues. My 2 cents. Cheers Moreno.
|
- [GENERAL] Move rows from one database to other Thomas Güttler
- Re: [GENERAL] Move rows from one database to other Adrian Klaver
- Re: [GENERAL] Move rows from one database to ot... William Ivanski
- Re: [GENERAL] Move rows from one database t... Melvin Davidson
- Re: [GENERAL] Move rows from one databa... Moreno Andreo
- Re: [GENERAL] Move rows from one databa... Thomas Güttler
- Re: [GENERAL] Move rows from one d... Melvin Davidson
- Re: [GENERAL] Move rows from o... Thomas Güttler
- Re: [GENERAL] Move rows fr... Adrian Klaver
- Re: [GENERAL] Move rows fr... Thomas Güttler
- Re: [GENERAL] Move rows fr... Francisco Olarte
- Re: [GENERAL] via psycopg2... Thomas Güttler
- Re: [GENERAL] via psycopg2... Francisco Olarte
- Re: [GENERAL] Move rows fr... Francisco Olarte
- Re: [GENERAL] Move rows fr... Leknín Řepánek