We have configured
postgres_fdw to move data from a DB to remote DB. It works fine but the large object field's data in source db not getting copied to remote DB.
This is the statement used to copy:
INSERT INTO archive_remote.target_db(id, oid_field) SELECT a.id, a.oid_field FROM appl.source_db a ON CONFLICT DO NOTHING;
Both databases are Postgres 9.6.
What is the right way to fix this?