A standard ODB database connector can provide access to the back-end PostgreSQL database server. However, it is not possible to securely provide a public connection to one of the production BETYdb databases. If you would like to use PostgreSQL to access BETYdb, you can also install a version of BETYdb on your own comptuer
Many users of PEcAn install a local copy of BETYdb, and BETYdb can sync across different servers, sharing public data over the network. The Distributed BETYdb chapter of the BETYdb Technical Documentation describes the network of independently hosted instances of BETYdb, and how to keep them in sync.
Scripts used to keep these databases in sync are maintained in the PEcAn Project repository provides useful configuration files. Their use is described in the developer's guide to installing PEcAn. The BETYdb installation chapter of the PEcAn Documentation explains how to import public data from one of the instances of BETYdb on the network.
First, download the
load.bety.sh script. Then
# Setup database with user betysudo -u postgres createuser -d -l -P -R -S betysudo -u postgres createdb -O bety bety# Download load.bety.sh scripthttps://raw.githubusercontent.com/PecanProject/pecan/master/scripts/load.bety.shchmod +x load.bety.sh# see description./load.bety.sh -h# create database and load data from remote site 0 (betydb.org)sudo -u postgres ./load.bety.sh -c YES -u YES -r 0# add data from remote site 1 (Boston University)sudo -u postgres ./load.bety.sh -r 1# TERRA REF public data:sudo -u postgres ./load.bety.sh -r 6