Posts

Postgres Plus Hot-standby Streaming replication

By -
Image
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...
Post a Comment
Read more

RDBMS and NoSQL

By -
Image
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....
Post a Comment
Read more

Secure Email (Outlook Express) with Digital Certificate

By -
Part I: Export of Digital Certificate and Private Key Login as administrator onto Certificate Server (Windows server 2003 with IP xxx.xxx.xxx.xxx)    Step-I.  Active Directory User Creation              Start à Programs à Administrative Tools à Active directory users & computers à right click testcert.digitalcert.com à new à user à create user by giving required details. Right click on newly created user à properties à Enter e-mail id for the user under       E-mail field à apply à OK   Step-II. Digital Certificate Creation              Open Internet Explorer with URL             http://xxx.xxx.xxx.xxx/certsrv   login with newly created username and password.             Request a certificate à Advanced certific...
2 comments
Read more

Installation of Oracle 10g On RHEL5

By -
Installation of Oracle 10g On RHEL5 Step 1:-- Disable the selinux. Step 2:-- Turn of the iptables. STEP 3:-- Create a hostname and domain name in the /etc/hosts file Step 4:-- Set the kernel parameters #vim  /etc/sysctl.conf Kernel.shmall  =  2097152 kernel.shmmax  =  2147483648 kernel.shmmni  =  4096 kernel.sem   =  250  32000 100  128 Fs.file-max = 65536 net.ipv4.ip_local_port_range = 1024 65000 net.core.rmem_default  = 262144 net.core.rmem_max  =  262144 net.core.wmem_default   =  262144 net.core.wmem_max   =  262144 step 5 :-- Run the following command to change the current kernel parameters #/sbin/sysctl  -p Step 6 :-- Add  the following line into the /etc/pam.d/login #vim  /etc/pam.d/login session        required          ...
Post a Comment
Read more