How to Make it so the GWAVA Appliance is Using SQL Instead of Postgres.

  • 7020843
  • 02-Jun-2014
  • 07-Aug-2017

Environment

:
GWAVA 6.5+
Appliance only

Situation

: The Postgres directory under /opt/beginfinite/gwava is larger then our server can handle. How can I switch from using Postgres to SQLite?

Resolution

:
If you need to switch from Postgres to SQLite for whatever reason, you will need to start over with a new database. To do that do the following:

1) Any settings you want to bring over into the new db, copy into a text doc. (such as source address exceptions).
2) Shutdown GWAVA by typing from a prompt: rcgwavaman stop

3) Rename gwavaman.db and identity.xml by typing:
cd /opt/beginfinite/gwava/config <hit enter>
mv gwavaman.db gwavaman.db.postgres
<hit enter>
mv identity.xml identity.xml.postgres <hit enter>

4) Delete appliancedb.shtml by typing:

cd /opt/beginfinite/gwava/assets/autorun/scripts/processed <hit enter>
rm appliancedb.shtml <hit enter>
5) Start GWAVA by typing:
rcgwavaman start
6) Open a browser to http://serverIP:49282 and go through the 3 step install process. During step 2, ensure that the 'Database type' is set to 'Internal', as this is SQL.

7) Continue through the install process as any normal install. Here is a install guide if needed: INSTALL GUIDE.

8) Copy settings you made a note of in step 1 back in.

You can now safely remove the contents of the postgres directory, located in /opt/beginfinite/gwava.

NOTE: It's not necessary, but if you'd like to stop postgres and keep it from starting up after a reboot you can do that by typing:
rcpostgresql-9.1 stop <hit enter>
insserv -r postgresql-9.1 <hit enter>
chkconfig -l postgresql-9.1 <hit enter>
Postgres should be shutdown now as well as it shouldn't load the next time the server is restarted.

Additional Information

This article was originally published in the GWAVA knowledgebase as article ID 2303.