DVR: System Configuration Procedure

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...

In the market various type of Database options are available like RDBMS, NoSQL, Big Data, Database Appliance, etc. developers can get very confused with all the choice. They do not understand why they should consider a newer, alternative database when RDBMSs have been around for 25+ years. However, many big enterprises are already using alternative databases and are saving money, innovating more quickly, and completing projects. Relational Database Management System (RDBMS) RDBMS  is a relational database. It is the standard language for relational database management systems.Data is stored in the form of rows and columns in RDBMS. The relations among tables are also stored in the form of the table.  SQL (Structured query Language) is a programming language used to perform tasks such as update data on a database, or to retrieve data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, etc....