Dasun's Tutorials

Some Slony1 Concepts (Official Docs) If you are familiar with slony concepts jump ahead to Start Replicating. Node Is a named PostgreSQL database instance that will be participating in replication. Cluster Is a named set of PostgreSQL database instances (i.e. nodes). Replication takes place between the set of database instances. Replication Set Is a set of tables and sequences that are to be replicated between the nodes. Each replication set has an origin and can have zero to many subscribers. The replication set is a key concept in the slony1 architecture. This concept provides...

Installing postgresql 9.5 Install the official PostgreSQL yum repository from the list of repositories at http://yum.postgresql.org/repopackages.php For installing postgresql 9.5 on centos 7 use the following command yum install https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-7-x86_64/pgdg-centos95-9.5-2.noarch.rpm For CentOS6 this is yum install https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-6-x86_64/pgdg-centos95-9.5-2.noarch.rpm Once done install the required postgresql packages such as server, contrib, etc. Naming convention of packages i...