postgres stuff start at 11:50
Will failover/failback steps will be same if we deploy PostgreSQL on AKS? Because I am not able execute vi,pgctl commands in container postgresql.
Why did we disabled the SELINUX?
Why don't u use slots? It's much faster and effective. Archiving is kinda old-fashioned.
I am have implemented master-slave streaming replication with postgresql10, I would like to upgrade from postgresql10 to postgresql11. I am aware that streaming replication only supports the same version of PostgreSQL.
Can you let me know what are the ways to achieve the upgrade process in streaming replication?
What's the size of the cluster ?
How much is downtime allowed by business ?
while doing pg_basebackup as per your instruction it is showing that "directory exist but it is not empty" so i rename data to data1 and created new data folder and did pg_basebackup. but postgresql is not starting when i do systemctl start postgresql-15.
Thank you so much for providing all details, Sir.