Hi Philipp, let's recap what I did. I have an application (DMS) that store images as large objects into the database. All tables used by the application are inside a single schema. A database usually host many application instances in many different schemas. (So, as I now understand, all large objects are mixed together into the same pg_public schema.)
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. The resulted database have all tables, all records, but no large objects. You say this is not a bug of pg_restore, I think it is. Anyway, could you tell me how I should have done such migration? Thank you very much, Giuseppe -- To UNSUBSCRIBE, email to [email protected] with a subject of "unsubscribe". Trouble? Contact [email protected]
