Question about large object Postgres

English Forum
1

Hi All
I would like to know more about wich tables store large object and create link in this table pg_largeobject_metadata.
Dumping only dump DB Tables data, but not large objects.

Thanks
Fabio

2

Hi @fabiobottan

The aim is only to dump the DB without large objects ? In this case why not try --no-blobs option when dumping ?

3

Hi @matthias actually my aim is clone full DB and move in different server tablespace if necessary.
I think I dumped it without blobs and in a different server I get some errors for some entities.

Fabio

4

I found some blobs in meta_file table, is that what you look for ?

5

I think so. Will chek it.
Becuase I’m studying the connection with this table pg_largeobject_metadata

6

I couldn’t find blobs in my meta_file table.

Schermata del 2020-07-09 15-49-06
Schermata del 2020-07-09 15-49-06956×481 63.6 KB

7

My bad MetaFile is for binary not blob

“The image widget is used with binary fields that stores image data or many-to-one fields referencing com.axelor.meta.db.MetaFile records.”

I think all binary files are here, i changed in application.properties :

# Maximum upload size (in MB)
# ~~~~~
file.upload.size = 5000

And upload a 4Go file and it is now in meta_file table

8

Exactly then it store physically the file in path you configured, meta table keed file name and path to return.
I did some experimenting to copy a whole DB from server A to B and now some users show this error

ERROR 27079 — [nio-8080-exec-9] com.axelor.rpc.ResponseInterceptor : SQL Error: ERROR: large object 109620 does not exist