Opnefire installation guide in Linux (Red Hat)

# yum install postgresql postgresql-server postgresql-libs   

# rpm -ivh openfire-3.8.2-1.i386.rpm

# cat /etc/passwd | grep postgres  
postgres:x:26:26:PostgreSQL Server:/var/lib/pgsql:/bin/bash

Home Directory: /var/lib/pgsql   
Default Shell: /bin/bash   
Default Password: None

# passwd postgres

# su - postgres

-bash-4.1$ initdb --pgdata=/var/lib/pgsql/data  
 The files belonging to this database system will be owned by user "postgres".  
 This user must also own the server process.

The database cluster will be initialized with locale en_US.UTF-8.  
 The default database encoding has accordingly been set to UTF8.  
 The default text search configuration will be set to "english".

creating directory /var/lib/pgsql/data ... ok  
 creating subdirectories ... ok  
 selecting default max_connections ... 100  
 selecting default shared_buffers ... 32MB  
 creating configuration files ... ok  
 creating template1 database in /var/lib/pgsql/data/base/1 ... ok  
 initializing pg_authid ... ok  
 initializing dependencies ... ok  
 creating system views ... ok  
 loading system objects' descriptions ... ok  
 creating conversions ... ok  
 creating dictionaries ... ok  
 setting privileges on built-in objects ... ok  
 creating information schema ... ok  
 vacuuming database template1 ... ok  
 copying template1 to template0 ... ok  
 copying template1 to postgres ... ok

WARNING: enabling "trust" authentication for local connections  
 You can change this by editing pg_hba.conf or using the -A option the  
 next time you run initdb.

Success. You can now start the database server using:

    postgres -D /var/lib/pgsql/data  
 or  
     pg_ctl -D /var/lib/pgsql/data -l logfile start   

$ su - root

# /etc/init.d/postgresql start  
Starting postgresql service:

[  OK  ]

# useradd deepak   
# passwd deepak

# su - postgres  
-bash-4.1$ createdb openfire  
-bash-4.1$ psql openfire  
psql (8.4.13)  
Type "help" for help.

openfire=#

CREATE USER deepak WITH PASSWORD 'example123';  
 CREATE ROLE  
 openfire=# GRANT ALL PRIVILEGES ON DATABASE openfire to deepak;  
 GRANT

openfire=# q

Login as deepak

-bash-4.1$ su - deepak  
Password:

[deepak@test ~]$ psql -d openfire -U deepak  
psql (8.4.13)  
Type "help" for help.

openfire=>

[FATAL: no pg_hba.conf entry for host "localhost", user "myuser", database "openfire", SSL off](/2013/09/fatal-no-pghbaconf-entry-for-host/)

# cd /opt/openfire/bin  
# ./openfire.sh   
Openfire 3.8.2 [Sep 21, 2013 6:09:18 PM]   
Admin console listening at:   
 http://10.10.20.26:9090  
 https://10.10.20.26:9091