Hi,
I've built a Pyramid "file management" application using RelStorage with a PostgreSQL back-end.
The ZODB is actually storing 2 millions files (for more than 2 Tb of storage) which are stored as ZODB blobs in "shared" mode (which is not recommended anymore), using NFS to share the storage between clients (which are also using a local NFS cache).
I'm thinking about switching to a new environment, using native PostgreSQL blobs, with streaming replication to several read-only servers (which is handled natively by RelStorage), but:

• is there any drawback to PostgreSQL blobs against ZODB shared blobs with this kind of metrics?
• I was using a simple pg_dump before a file system backup, but this doesn't seem possible anymore; what is the best way to manage PostgreSQL backups when using native blobs of this size?

Best regards,
Thierry