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.klaver@aklaver.com