"Cyril VELTER" <cyril.velter@metadys.com> writes: > I'm trying to dump a database from a 7.1.3 server to a 7.4.2 one. > > It doesn't works because of difference in COPY format (unless I use -d > which is VERY slow on a 16G database). Try using the 7.4.2 version of pg_dump to dump out the 7.1.3 database. pg_dump is written to talk to multiple versions of the server, and it's generally recommended to use the same version of pg_dump as the server you're restoring into. -Doug ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
