I’m trying to backup from one database and restore on other database both with the same version(12.9). I have one table with large objects(OID) and when I restore the backup the large objects are missing. I have the OID on the table but when I select the large object with the OID does not exist. No errors are showm just miss the data. I’m using dbeaver to backup and restore.
I tried to use the -O line command but no works.
1
If you dump or restore a single table, you have to use the additional option --large-objects (--blobs in old PostgreSQL versions) with pg_dump or pg_restore to also dump or restore the large objects.
6
The solution is to use -b on the command line. Increase the backup time from 5 minutes to 38 minutes. We decide to avoid large object and use just TEXT.