I want to know few details about streaming replication.
I want to setup streaming replication between version 9.4.4 and 9.4.20 ?
I have the master server in centos6.6 with postgres version 9.4.4 which is a physical machine and we have created a new virtual machine centos7.5 and postgres version is 9.4.20. I want to know if this will cause any problem due to version mismatch.
Also, How can I download specific minor version 9.4.4 of postgres ? I checked some official documentation and by yum I am able to see only 9.4 which is actually 9.4.20 after I installed.
Best Answer
AFAIK it will work and documentation says, it should work.
https://www.postgresql.org/docs/9.4/warm-standby.html
For upgrade process
If you installed PostgreSQL via yum, yum update postgresql* should work. If you need rpms here is the PostgreSQL download link;
http://download.postgresql.org/pub/repos/yum/9.4/redhat/