On 2/1/21 1:28 PM, Andrus wrote:
Hi!

 >Long term figure out what they are and if they are needed or not.

Non-superuser backup worked earlier. It looks like large objects suddenly appeared in database:

select * from  pg_largeobject_metadata

Oid                      Lomowner

200936761       30152
200936762      30152
200936767       30152

How to figure out what are large object with oids   200936761, 200936762 and 200936767 ?

I misspoke earlier about large objects not being tied to a schema.table. They can be as a column of type oid.

To see if they are try :

SELECT
    relname,
    attname
FROM
    pg_attribute AS pa
    JOIN pg_class AS pc ON pa.attrelid = pc.oid
WHERE
    atttypid = 'oid'::regtype
    AND relnamespace = 'public'::regnamespace
    AND attnum > 0;

Where relnamespace is the schema you are interested in.


Pd_dump throws error on first of them: 200936761

Andrus.



--
Adrian Klaver
adrian.kla...@aklaver.com


Reply via email to