Follow Doc ID 2069351.1

Example of installing postgress SQL

First, just download the rpm from the Oracle yum repo
http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/x86_64/
Then, run

dcli -C rpm -uvh /var/tmp/postgresql-8.4.20-2.el6_6.x86_64.rpm
dcli -C rpm -uvh /var/tmp/postgresql-server-8.4.20-2.el6_6.x86_64.rpm

Now, Initialize postgress

chkconfig postgresql on
service postgresql initdb
service postgresql start

Create postgress database

su - postgres
psql -U postgres

# Modify postgres password
postgres=# ALTER USER postgres with encrypted password 'password';
ALTER ROLE

# Create sqoop user/role/password
postgres=# CREATE ROLE sqoop LOGIN ENCRYPTED PASSWORD 'password' NOSUPERUSER INHERIT CREATEDB NOCREATEROLE;
CREATE ROLE
postgres=# CREATE DATABASE "sqoop" WITH OWNER = sqoop;
CREATE DATABASE
postgres=# \q

# Allow to connect, Change  ident to md5
# tail /var/lib/pgsql/data/pg_hba.conf
host    all         all         127.0.0.1/32          md5
# IPv4 local connections:
host    all         all         10.10.10.51/32        md5
host    all         all         10.10.10.52/32        md5
host    all         all         10.10.10.53/32        md5
host    all         all         10.10.10.54/32        md5
host    all         all         10.10.10.55/32        md5
host    all         all         10.10.10.56/32        md5
# IPv6 local connections:
host    all         all         ::1/128               ident

# restart
service postgresql restart

Modify Sqoop to use postgress instead of derby
http://www.cloudera.com/content/www/en-us/documentation/enterprise/latest/topics/install_sqoop_ext_db.html