Environment
:
GWAVA 6.5+
Appliance only
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:
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:
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 stopYou can now safely remove the contents of the postgres directory, located in /opt/beginfinite/gwava.
3) Rename gwavaman.db and identity.xml by typing:
cd /opt/beginfinite/gwava/config <hit enter>4) Delete appliancedb.shtml by typing:
mv gwavaman.db gwavaman.db.postgres <hit enter>
mv identity.xml identity.xml.postgres <hit enter>
cd /opt/beginfinite/gwava/assets/autorun/scripts/processed <hit enter>5) Start GWAVA by typing:
rm appliancedb.shtml <hit enter>
rcgwavaman start6) 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.
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>Postgres should be shutdown now as well as it shouldn't load the next time the server is restarted.
insserv -r postgresql-9.1 <hit enter>
chkconfig -l postgresql-9.1 <hit enter>
Additional Information
This article was originally published in the GWAVA knowledgebase as article ID 2303.