On Tue, 2021-02-02 at 10:48 +0200, Andrus wrote: > > You can extract it with > > \lo_export 200936761 'somefile' > > > > in psql and examine the file. > > > > Ask the people who use that database! > > Tried > > root@c202-76:~# ./pgsqlkaiv.sh > > psql (12.2 (Debian 12.2-2.pgdg100+1)) > Type "help" for help. > > sba=# \lo_export 200936761 'large200936761' > lo_export > sba=# \q > > root@c202-76:~# ls -l large* > -rw-r--r-- 1 root root 0 veebr 2 10:45 large200936761 > result file size is 0 .
So? What is your point? Somebody created a large object of size 0. Don't ask me who did it, ask the people who use this database. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
