On 2/1/21 3:07 PM, Andrus wrote:
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.
I don't suppose this was done in a structured way that could be gone
back over?
Cluster contains 25 databases. There are 50 users executing SELECT,
INSERT, UPDATE, DELETE, CREATE, DROP and similar commands.
Yeah, but you are only concerned with one database and two schemas.
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
Actually there is a second lo_export() at bottom of page. It needs
superuser privilege and access to the server file system.
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.
What happens if you query:
https://www.postgresql.org/docs/12/catalog-pg-largeobject.html
as a superuser?
Do you see anything in the data field?
Andrus.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
