Hi!
> What code changed between the last backup and today?
I have imported data from other clusters and executed lot of
different sql commands. I have used grant, revoke, reassign
commands to change privileges for other users and have deleted and
added users.
Cluster contains 25 databases. There are 50 users executing SELECT, INSERT, UPDATE, DELETE, CREATE, DROP and similar commands.
dumpuser has rights only to one database and two schemas (public
and firma74 ).
You could try some of the functions here:
https://www.postgresql.org/docs/12/lo-funcs.html
to see if you can figure it out.
There is only one function , lo_get() in this page which returns data. I tried
select * from lo_get(200936761);
select * from lo_get(200936762);
select * from lo_get(200936767);
Those queries returned one row containing one zero-length column lo_get.
Andrus.