Biswajit: Created page with "category:AIMIL == HRMS APPLICATION with JBOSS and PostgreSQL at AIMIL == by Rajneesh Lamba 1)Ist install java,php,php-pgsql,phpPgadmin,httpd 2)If phpPgAdmin not in..."

2013-01-05T03:23:17Z

Created page with "category:AIMIL == HRMS APPLICATION with JBOSS and PostgreSQL at AIMIL == by Rajneesh Lamba 1)Ist install java,php,php-pgsql,phpPgadmin,httpd 2)If phpPgAdmin not in..."

New page

[[category:AIMIL]]

== HRMS APPLICATION with JBOSS and PostgreSQL at AIMIL ==
by Rajneesh Lamba

1)Ist install java,php,php-pgsql,phpPgadmin,httpd

2)If phpPgAdmin not installed from base repo you can configure epel repo for that.

3)install jboss final(ot transfer from other place where jboss run)

4)path of jboss /usr/bin/jboss_6.0___

5)also transfer jboss start/stop script from /etc/init.d/jboss

6)Now after all this install postgresql

INSTALL THESE PACKAGES

# yum install postgresql*

It install following packages
postgresql-server
postgresql-libs
postgresql84-contrib

NOW RUN THIS COMMAND TO CREATE DATA DIR IN /var/lib/pgsql/
#service postgresql initdb

AFTER RUNNING ABOVE COMMAND YOU GET A DIR /var/lib/pgsql/data

Now Start Postgresql
#/etc/init.d/postgresql start
#chkconfig postgresql on
#chkconfig httpd on

Login in Postgresql
#su - postgres
-bash-3.2$ psql postgres

postgres=#CREATE DATABASE aimil WITH TEMPLATE = template0 OWNER = postgres
ENCODING = 'UTF8';

ABOVE COMMAND CREATES A DATABASE OF NAME(WHATEVER YOU GIVE "HERE i GIVE
DATABASE NAME aimil") WITH UNICODE UTF8

postgres=#ALTER USER postgres with PASSWORD 'password'; (HERE GIVE
PASSWORD TO USER POSTGRES)

postgres=#quit (to logout)
-bash-3.2$psql -l (to check database list)

logout and come back on root prompt
#vim /var/lib/pgsql/data/pg_hba.conf

go in last and add global ip of tetra there with md5 encription

local all all md5
host all all 127.0.0.1/32 md5
host all all 122.160.21.105/24 md5 (tetra global IP)
host all all 203.122.16.189/32 md5 (postgresql server global IP)
host all all 192.168.0.0/24 md5 (local network range of client network)

save and quit

#vim /var/lib/pgsql/data/postgresql.conf

listen_addresses = '*' put * in place of 'localhost'
port = 5432 remove #
max_connections = 100 remove #

save and quit

#vim /etc/httpd/conf.d/phpPgAdmin.conf

Allow from all (allow all here)

#vim /etc/phpPgAdmin/config.inc.php

change true in false here

$conf['extra_login_security'] = false;

#/etc/init.d/postgresql restart
#/etc/init.d/httpd restart

enjoy:)

NOW IF YOU HAVE TO TAKE ANY DUMP OF OTHER POSTGRESQL DATABASE

go to that server

#su - postgres

pg_dump databaseName > databaseName.sql

make tar of databaseName.sql and transfer on new postgresql server.

On new server where you install new postgresql or where you want to upload this database type

#su - postgres

#psql -d databasename -f databaseName.sql ( to upload database in postgresql)

#psql_dump database > database.sql ( to take dump of DB )

THATS IT

HRMS APPLICATION with JBOSS and PostgreSQL at AIMIL - Revision history

Biswajit: Created page with "category:AIMIL == HRMS APPLICATION with JBOSS and PostgreSQL at AIMIL == by Rajneesh Lamba 1)Ist install java,php,php-pgsql,phpPgadmin,httpd 2)If phpPgAdmin not in..."