Objective : Set up two DB server if first server down then second can be up and running provided condition is that at evening time both server need to sync. with each other
I am new in DBA and we are using PostgreSQL 9.6 and thinking to use PostgreSQL 10.0. We have regular data in tables along with that we have large spatial data (GIS related data having 'postgis' extension) on Windows Platform
We checked few replication tools in which 'Slony' tool is comes with default installation hence we want to use for replication.
we are checking this link for reference as well as documentation.
If anyone knows proper technical article including required steps then it would great!!