Project

General

Profile

Statistics
| Revision:

root @ 11451

Name Size Revision Age Author Comment
  BIEN2 10896 about 11 years Aaron Marcuse-Kubitza added BIEN2/traits_observation_counts.xls
  _archive 1598 over 12 years Aaron Marcuse-Kubitza Moved _archive/tapir2flatClient/trunk/client/ t...
  backups 11355 about 11 years Aaron Marcuse-Kubitza backups/TNRS.backup.md5: updated
  bin 11434 about 11 years Aaron Marcuse-Kubitza bin/make_analytical_db: removed no longer neede...
  config 7801 over 11 years Aaron Marcuse-Kubitza root Makefile: VegBIEN DB: mk_db: Added command...
  derived 11450 about 11 years Paul Sarando Added db user and host to load-geoscrub-input.s...
  exports 11437 about 11 years Aaron Marcuse-Kubitza exports/2013-10-18.Brian_Enquist.Canadensys.csv...
  inputs 11440 about 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: added %/import_temp alia...
  lib 11436 about 11 years Aaron Marcuse-Kubitza added lib/runscripts/import_subset.run, extract...
  mappings 11107 about 11 years Aaron Marcuse-Kubitza bugfix: mappings/VegCore-VegBIEN.csv: nest all ...
  planning 11441 about 11 years Aaron Marcuse-Kubitza planning/timeline/timeline.2013.xls: reload cor...
  schemas 11451 about 11 years Aaron Marcuse-Kubitza bugfix: schemas/pg_hba.conf: don't allow ident ...
  web 11403 about 11 years Aaron Marcuse-Kubitza web/links/index.htm: updated to Firefox bookmar...
.htaccess 326 Bytes 8771 over 11 years Aaron Marcuse-Kubitza /.htaccess: use canonical URL without symlinks
.rsync_filter.upload 33 Bytes 10042 over 11 years Aaron Marcuse-Kubitza /.rsync_ignore: temp files: hide them on upload...
.rsync_ignore 12 Bytes 10042 over 11 years Aaron Marcuse-Kubitza /.rsync_ignore: temp files: hide them on upload...
Makefile 12.7 KB 11150 about 11 years Aaron Marcuse-Kubitza /Makefile: mk_db: config/users.sql: unset ON_ER...
README.TXT 24.2 KB 11263 about 11 years Aaron Marcuse-Kubitza /README.TXT: Single datasource import: added po...
fix_perms 97 Bytes 7560 almost 12 years Aaron Marcuse-Kubitza Added root fix_perms
map 1001 Bytes 6949 almost 12 years Aaron Marcuse-Kubitza vegbien_dest: Changed default $prefix to "", so...
new_terms.csv 38.1 KB 7222 almost 12 years Aaron Marcuse-Kubitza new_terms.csv: Regenerated
run 661 Bytes 10881 about 11 years Aaron Marcuse-Kubitza /run: geoscrub_input/make(): updated runtime (2...
unmapped_terms.csv 13.1 KB 7201 almost 12 years Aaron Marcuse-Kubitza **/new_terms.csv, **/unmapped_terms.csv: Regene...

Latest revisions

# Date Author Comment
11451 10/29/2013 01:22 AM Aaron Marcuse-Kubitza

bugfix: schemas/pg_hba.conf: don't allow ident authentication for Unix socket connections, because this apparently prevents having normal, password-based connections ("md5"). note that just switching the order of the ident and md5 entries is not useful, because whichever authentication type comes second will be ignored completely. this problem was previously worked around by just not using Unix socket connections at all, and always specifying "localhost" as the host to force a hostname-based connection. this does not affect the postgres superuser, because they have their own ident line in pg_hba.conf.
11450 10/25/2013 06:15 PM Paul Sarando

Added db user and host to load-geoscrub-input.sh

The psql commands in load-geoscrub-input.sh will now connect with a
specific user on a specific host.
Updated the 'COPY' sql statement to a '\COPY' statement, so that the
psql user does not have to be a PostgreSQL superuser.
11449 10/25/2013 04:51 PM Aaron Marcuse-Kubitza

derived/biengeo/README.txt: geoscrub new data: steps that use .sql scripts: added the psql commands to run these
11448 10/25/2013 04:22 PM Paul Sarando

Updated install instructions in the README.
11447 10/25/2013 03:00 PM Aaron Marcuse-Kubitza

derived/biengeo/README.txt: geoscrub new data: noted that this now deletes any previous geoscrubbing results
11446 10/25/2013 02:58 PM Aaron Marcuse-Kubitza

derived/biengeo/README.txt: added steps to set the working dir for each set of steps
11445 10/25/2013 02:54 PM Aaron Marcuse-Kubitza

derived/biengeo/README.txt: added section on obtaining source code, including path to Paul's in-progress files on vegbiendev (not sure whether the in-progress files are needed to run the core scripts in steps 1-6)
11444 10/25/2013 02:44 PM Aaron Marcuse-Kubitza

derived/biengeo/README.txt: moved commands to run to the top of the README. flagged commands-sections with *** and an identifying label.
11443 10/25/2013 02:04 PM Paul Sarando

Initial checkin of geoscrub install SQL files.

Added install.*.sql files that will do initial table creation for all
required tables.
Added a truncate.vegbien_geoscrub.sql script that will clear tables related to
data downloaded in load-geoscrub-input.sh....
11442 10/25/2013 02:04 PM Paul Sarando

Update load-geoscrub-input.sh to download from URL.

Removed logic to dump input data directly from the vegbien database and
to download the input from a URL provided by AMK instead.
Also updated this script to download the file into an input data
directory, rather than just into the current working directory.

View all revisions | View revisions

Also available in: Atom