Re: [GENERAL] Restore LargeObjects on different server

2017-10-13 Thread Daniel Verite
Durumdara wrote: > The pg_catalog schema is system schema, but it is IN the DB. > > Is this true? So OID is not global (out from DB)? The OID generator is global to the instance, but the unicity checks are local to the tables that use OIDs, including large objects. The case when you may

Re: [GENERAL] Restore LargeObjects on different server

2017-10-12 Thread Laurenz Albe
Durumdara wrote: > > Because of upload/download progress we used LargeObjects to store some > > files in one of our database (and not bytea). > > Only this database uses the OID-s of these files. > > > > In the near future we must move to another server. > > This new server is also working now, t

Re: [GENERAL] Restore LargeObjects on different server

2017-10-12 Thread Durumdara
Hi! Somebody wrote me that: The pg_catalog schema is system schema, but it is IN the DB. Is this true? So OID is not global (out from DB)? So we can dump and restore the DB with OIDs without collision in new server? Thank you! dd 2017-10-12 11:35 GMT+02:00 Durumdara : > Dear Members! > > Be

[GENERAL] Restore LargeObjects on different server

2017-10-12 Thread Durumdara
Dear Members! Because of upload/download progress we used LargeObjects to store some files in one of our database (and not bytea). Only this database uses the OID-s of these files. In the near future we must move to another server. This new server is also working now, the moving of databases is