PostgreSQL Dependency tree

Hi community! I need to understand the dependency tree in my DB. The order of INSERT into each table based on FKs. I know there is the pg-depend catalog , but I figured before spending some time writting the SQL statement, I would as

PG 9.2 slave restarted - cache not impacted

Hi guys, I'm a bit confused about PG cache. I have a PostgreSQL 9.2 cluster (yes, we're planning on upgrading it to 12) with a master and a slave database. The application is sending all read requests to the slave, where the master processes the writes. A while ago we had to restart the master

PostegreSQL 9.2 to 9.6

Hi guys. We need to upgrade (asap) our PostgreSQL 9.2 cluster. We run our cluster on AWS EC2 instances, and want to upgrade to RDS 9.6. Once in RDS, it makes easier for us to major upgrade to 11. Since this upgrade must be done with minimal downtime, my original idea was to use Bucardo

Upgrading 9.2 to 9.6 questions

Hi. We have a setup of 3 Postgres 9.2 nodes (1x master, 2x slaves) running on EC2 instances in AWS. We want to upgrade to 9.6 so we can move to Amazon RDS (it requires at least a 9.3.5 version ). As far as I know, we hav