Il giorno lun, 31/01/2011 alle 11.49 +0100, Martin Pitt ha scritto: > Hello Giuseppe, > > Giuseppe Sacco [2011-01-31 11:24 +0100]: > > Now, I tried to move one application instance from one database in lenny > > to one database in squeeze. So, I exported the complete database with > > pg_dump and imported only one schema using pg_restore with option > > --schema. > > Did you use --format for this? The SQL (plain text) format isn't > supposed to have blobs, as you cannot sensibly represent them. The > "custom" and "tar" formats can deal with blobs.
I think I used custom: giuseppe@titanium4:~$ file dump-20100528.pgdump dump-20100528.pgdump: PostgreSQL custom database dump - v1.10-0 Bye, Giuseppe -- To UNSUBSCRIBE, email to [email protected] with a subject of "unsubscribe". Trouble? Contact [email protected]
