POSTGRES) Questions about the blob dump

Asked

Viewed 46 times

0

I’m at an impasse, but so far, even though I’ve done a lot of research, I haven’t found a viable solution.

On a Postgresql9.6 server, I’m trying to back up one of the Databases. However, it has a large volume of large objects (mostly blob’s). Assuming the bank is 100gb, 50gb are only blob’s.

I would therefore like a way to back it up without these structures.

In the pg_dump documentation: https://www.postgresql.org/docs/9.6/app-pgdump.html found the following excerpt:

-b

--blobs

Include large Objects in the dump. This is the default behavior except when --schema, --table, or --schema-only is specified. The -b switch is therefore only Useful to add large Objects to dumps Where a specific schema or table has been requested. Note that blobs are considered data and therefore will be included when --data-only is used, but not when --schema-only is.

How can I backup without blob’s?

postgresql

1 answer

1


I think you should refer to the following option in the documentation:

-B
--no-blobs

    Exclude large objects in the dump.

    When both -b and -B are given, the behavior is to output large objects, when data is being dumped, see the -b documentation.

Browser other questions tagged postgresql

You are not signed in. Login or sign up in order to post.