Postgres Plus Hot-standby Streaming replication
PPAS Postgres Plus Advanced Server (PPAS) 9.2 Installation, initial configuration, Hot-standby Streaming replication Step 1:-- unzip the installation archive file. Step 2:-- Make the installer directory your current directory Note 1:-- while installation when asked for either an oracle or postgresql installation select oracle will give you all of the oracle performance and scability features not found in community postgreSQL. Note 2:-- Enter the password for the database super user. Be sure remember this you will need the password later. Install the PPAS on both the primary and secondary server. On primary server Installation directory :/opt/PostgresPlus/9.2AS Data Directory : /opt/PostgrePlus/9.2AS/data WAL Directory : /opt/PostgresPlus/9.2AS/data/pg_xlog Database port :5444 Database Superuser : enterprisedb Operating System Account: enterprisedb Database Service :ppas-9.2 Pg_bouncer: 6432 On secondary...