Replication between different 15.x minor versions ok?

2023-06-28 Thread David Tinker
Is it ok to use physical replication between different 15.x minor releases (on Ubuntu 22.04)? I haven't been able to find a definitive answer. Thanks.

Postgres as a LRU cache?

2023-04-18 Thread David Tinker
Has anyone tried using Postgres as a LRU cache for data in cloud blob storage? I have a lot of data in Cassandra and want to move that to Backblaze (like S3 but cheaper and less available). Cassandra is working well but I have to add new nodes more frequently that I would like. The older data is

How much shared memory does Postgresql need per max_locks_per_transaction?

2020-11-30 Thread David Tinker
I have a Postgresql 10 database with about 300k tables in 23k schemas. I am trying to upgrade to Postgresql 13 using pg_upgradecluster. This is failing while attempting dump all the schemas: pg_dump: error: query failed: ERROR: out of shared memory HINT: You might need to increase