PostgreSQL Question posted in
The official documentation can be found here.

Postgresql – How to backup data including large objects from Postgres

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.

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    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.


  2. 0

    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.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search