To access the GridGuard DB, the firewall on the server has to be reconfigured to open up the necessary ports.

1. Connect to the GridGuard server via SSH. Login as gridadmin
2. Run command sytem-config-security-level
3. Choose option Customize
4. Under Allow Incoming, add entry tcp:5432
5. Select OK
6. Select OK
7. Run command service iptables restart

Download pgAdmin III from the following URL and install the tool.

http://www.pgadmin.org/download/ and install

If you need to connect to the database using an alternate tool, you can download the database drivers from the following URL:

http://ftp.postgresql.org/pub/odbc/versions/msi/

GridGuard currently runs version PostgreSQL 9.0.

To configure the pgAdmin tool, first determine the connection settings (username & password). To do this

1. Connect to the GridGuard server via SSH. Login as gridadmin
2. Run command grep "postgresql" /etc/syferlock/gridserver/server.xml
3. This will give you a single line formatted as given below. Note down the value of the username and password attributes

<Resource auth="Container" driverClassName="org.postgresql.Driver" name="jdbc/Store" type="javax.sql.DataSource" url="jdbc:postgresql://localhost/grid" username="<username>" password="<password>" maxActive="20" maxIdle="0" maxWait="60" removeAbandoned="true" removeAbandonedTimeout="12600"/>

1. Select menu option File > Add Server
2. Set name to any name you will like to assign to connection
3. Set host to ip address / hostname of the GridGuard server
4. Set username to the username determined in the previous step
5. Set password to the password determined in the previous step
6. Click OK

The GridGuard database objects will be displayed under the node Databases > Schemas > grid