to test the import:

# -> "to set up the VM"

# restore the "booted" snapshot under "+pg_restore"

# start the VM

ssh -t 128.111.220.240

$0 # nested shell

export version=test_import

declare -ax inputs; inputs=(inputs/ARIZ/)

. bin/import_all # runtime: 50 min ("0:45:07.105389"+"4:05.03")

kill % # cancel after_import()

to set up the VM:

ln -s /Volumes/vegbiendev/vegbiendev.vdi ~/VirtualBox\ VMs/vegbiendev/vegbiendev.vdi

screen

# press ENTER

l=1 overwrite=1 inplace=1 src=/Volumes/vegbiendev/vegbiendev.vdi dest=~/VirtualBox\ VMs/vegbiendev/vegbiendev.file.vdi put # runtime: 5 h ("4:43:16")

	# move vegbiendev.vdi to the internal hard drive

# press Ctrl-D

(cd ~/VirtualBox\ VMs/vegbiendev/; mv vegbiendev.file.vdi vegbiendev.vdi)

# open VirtualBox

# select the vegbiendev VM

# restore the "+bootloader+VirtualBox Guest Additions+eth1" snapshot

# open Settings > System tab

# in the Motherboard subtab, set Base Memory to 2048 MB

# in the Processor subtab, set Processor(s) to 1

# boot the VM

# when asked whether to skip mounting, press S

ssh -t 128.111.220.240

rm inputs/GBIF/_MySQL/GBIFPortalDB-2013-02-20.data.sql

sed --in-place -r 's/^(shared_buffers = )\S+/\11000MB/' schemas/postgresql.conf

	# = <1 GB; decrease to match VM's allocated memory (2 GB)

sudo mkdir -p /var/lib/postgresql/9.3/main/

sudo chown postgres:postgres /var/lib/postgresql/9.3/main/

sudo -E -u postgres /usr/lib/postgresql/9.3/bin/initdb -D /var/lib/postgresql/9.3/main/

sudo ln -sf /etc/postgresql/9.3/main/*.conf /var/lib/postgresql/9.3/main/

make postgres_reload

# at "Modifying postgresql.conf and pg_hba.conf", type y and press ENTER

# at "kernel.shmmax ... Press ENTER to continue", press ENTER

# at "restart PostgreSQL manually ... Press ENTER to continue":

# open a new window

ssh -t 128.111.220.240

# run what it says

# press Ctrl-D

# return to the previous window

# press ENTER

* to use a database backup:

# {

make mk_db # restore users, which are not part of the backup

screen

# press ENTER

l=1 src='starscream.nceas.ucsb.edu:~/bien/' dest=. put backups/vegbien.r12025.backup # runtime: 25 min ("0:25:24")

# press Ctrl-D

sudo chgrp postgres backups/vegbien.r12025.backup

sudo halt

# at "System halted", close the VM and *uncheck* Restore current snapshot

# create a VM snapshot named "+initdb+database backup"

# boot the VM

# when asked whether to skip mounting, press S

ssh -t 128.111.220.240

screen

# press ENTER

time for schema in temp util py_util geoscrub herbaria IRMNG IUCN NCBI newWorld TNRS ARIZ; do

	bin/psql_verbose_vegbien <<<"CREATE SCHEMA \"$schema\";"

	"time" sudo -E -u postgres pg_restore --exit-on-error --verbose --dbname=vegbien --schema="$schema" backups/vegbien.r12025.backup

		# need to run as DB superuser to restore py_util

done # runtime: 15 min ("11:44:05" - ~11:30)

	# must use for loop because pg_restore doesn't support multiple --schema

	# options (it just uses the last one)

	# (http://postgresql.1045698.n5.nabble.com/pg-restore-should-accept-multiple-t-switches-td2399138.html)

# press Ctrl-D

sudo halt

# at "System halted", close the VM and *uncheck* Restore current snapshot

# create a VM snapshot named "+pg_restore"

# boot the VM

# when asked whether to skip mounting, press S

# create a VM snapshot named "booted"

# close the VM and *check* Restore current snapshot

# }

* to use a clean database:

# {

(cd inputs/; for dir in IRMNG IUCN newWorld; do mv "$dir" ."$dir"; done)

(cd inputs/; for dir in */; do dir="${dir%/}"; case "$dir" in analytical_db|ARIZ) : ;; *) mv "$dir" .archive/"$dir";; esac; done)

make misc-Linux db inputs/install schemas/public/reinstall # runtime: 15 min ("15:11:16".."15:26:28") @starscream.vegbiendev

# at "This will delete the current public schema of your VegBIEN DB", type y and press ENTER

# }

to install system updates:

# boot the VM

# when asked whether to skip mounting, press S

sudo apt-get update

sudo apt-get dist-upgrade

sudo reboot # some system updates require system restart

# when asked whether to skip mounting, press S

sudo halt

# at "System halted", close the VM and *uncheck* Restore current snapshot

# create a VM snapshot named "+system updates"

# boot the VM

# when asked whether to skip mounting, press S

# create a VM snapshot named "booted"

to enable VM to access VirtualBox shared folders:

(currently doesn't work, likely because of a bug in VirtualBox Guest Additions when installed on something other than a clean Linux install)

sudo sed --in-place -r 's/^vboxsf:.*:$/&aaronmk/' /etc/group

# press Ctrl-D

ssh -t 128.111.220.240