BETYdb: Data Access
Search…
Overview
Web Interface Search
API for URL-based Queries
rOpenSci Traits Package
R dplyr Package
PEcAn R Package
SQL Queries
Installing Your Own Version of BETYdb
Appendix: Full Search Details
Powered By GitBook
Installing Your Own Version of BETYdb
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
1
# Setup database with user bety
2
sudo -u postgres createuser -d -l -P -R -S bety
3
sudo -u postgres createdb -O bety bety
4
​
5
# Download load.bety.sh script
6
https://raw.githubusercontent.com/PecanProject/pecan/master/scripts/load.bety.sh
7
chmod +x load.bety.sh
8
​
9
# see description
10
./load.bety.sh -h
11
​
12
# create database and load data from remote site 0 (betydb.org)
13
sudo -u postgres ./load.bety.sh -c YES -u YES -r 0
14
# add data from remote site 1 (Boston University)
15
sudo -u postgres ./load.bety.sh -r 1
16
​
17
# TERRA REF public data:
18
sudo -u postgres ./load.bety.sh -r 6
Copied!
Previous
SQL Queries
Next
Appendix: Full Search Details
Last modified 3yr ago
Copy link