tigran2-postgres@riatest.com wrote:
> Is there any other way to store large data in Postgres that allows
streaming and correctly works with
> multiple schemas per database?
Large Objects and bytea are the only ways.
If you want to pg_dump only certain large objects, that won't work
as far as I know (maybe using permissions and a non-superuser can help).
You absolutely need to pg_dump parts of the database regularly?
Yours,
Laurenz Albe