GREAT-ER defaultdata

This folder contains the default datasets to be installed with GREAT-ER
Server installation.

There are currently two ways. First is the slow variant using single sql
statements as they are contianed in the *.sql files the second way which
will be used by the greater installer is to use a postgresql backup
file to be imported with pg_restore.

Scripts should start with a number indicating the Order in which they
should be executed.

For the defaultdata you should look at the paths in the defaultdata
scripts and also into the bin_obj scripts.

After importing the bin objects you need to make sure that the
blob permissions are correctly. The user postgres has to do the
import and afterwards have to give them over to all greater users

select file_obj from bin_obj_tab;
and then in your editor something like:
%s/^    /Grant all on large object /
%s/$/to greater_standard_role;

Afterwards create a backup dump of the database and put it into the defaultdata
folder with the name defaultdb.backup

For the sediment extentision import this database into a new database
called greater-sediment, execute the upgrate process as documented
in branches/greater_sediment for this db.
Finally create a dump of this db also and place it into sedimentdb.backup