for 32bit
http://update.panagenda.com/gl2pkg/greenlight-2.deb
for 64bit
http://update.panagenda.com/gl2pkg_amd64/greenlight-2.deb
When you are running the 32 bit appliance box the welcome screen will appear in text mode. If you are running a 64 bit appliance you see a graphical login (left picture).
Check the Ubuntu Version Level.
If you see v12.x then you are on 64 bit.
If you see v8.x then it is an 32 bit appliance
A01 - 32bit: stop tomcat
open terminal window: sudo /etc/init.d/tomcat stop
A02 - 32bit: PgAdmin - add role remote_connect to user greenlight
on desktop: right click – tools – database admin
A03 - 64bit: sudo su - postgres
A04 - 64bit: pg_dump --host <ip of the 32bit appliance> --username greenlight -Fp --schema-only greenlight > gl32bit_schema.dump
Note: The dump will be stored in /var/lib/postgresql on the 64 bit appliance
If you get a "connection refused" message then you need to adjust the "listenAddress line" withtin the postgresql.conf files so that it listens to 0.0.0.0 (not 127.0.0.1)
A05 - 64bit: pg_dump --host <ip of the 32bit appliance> --username greenlight -Fc --data-only greenlight > gl32bit_data.dump
Note: The dump will be stored in /var/lib/postgresql on the 64 bit appliance
B01 - 64bit: remove the following references from gl32bit_schema.dump with text editor (e.g. vim or leafpad)
-- Name: furigana(text); Type: FUNCTION; Schema: public; Owner: postgres
Up to(including)
ALTER FUNCTION public.ts_ja_start(internal, integer) OWNER TO postgres;
--> so "web_query" is the first line
B02 - 64bit: stop tomcat
open terminal window: sudo service tomcat stop
B03 - 64bit: PgAdmin - drop DB greenlight
open PgAdmin
drop greenlight DB
click on yes
B04 - 64bit: PgAdmin - recreate DB greenlight (owner greenlight)
B05 - 64bit: Import 32bit Schema Dump (if fails, back to B03)
psql greenlight -f gl32bit_schema.dump
B06 - 32bit: copy notes related files
enter: yes
enter the password: panagenda
B07 - 64bit: copy names.nsf to its final destination
cp names.nsf /lotus/notes/data
Note: user.id will not be copied (it will be uploaded via the GL frontend!)
B08 - 64bit: remove old Log files
sudo rm /opt/tomcat/logs/*
B09 - 64bit: optimize postgresql and tomcat
make sure postgresql.conf and /etc/defaults/tomcat are optimized to RAM --> link to tuning page
A06 - 64bit: restore data
pg_restore -d greenlight gl32bit_data.dump
A07 - 64bit: start tomcat
open terminal window: sudo service tomcat start
A08 - 64bit: login to GreenLight Webinterface
A09 - 64bit: reboot appliance