Project

General

Profile

Statistics
| Revision:

root @ 10836

Name Size Revision Age Author Comment
  _archive 1598 almost 13 years Aaron Marcuse-Kubitza Moved _archive/tapir2flatClient/trunk/client/ t...
  backups 10752 over 11 years Aaron Marcuse-Kubitza updated backups/TNRS.backup.md5
  bin 10742 over 11 years Aaron Marcuse-Kubitza bin/tnrs_db: add entry to new batch table
  config 7801 almost 12 years Aaron Marcuse-Kubitza root Makefile: VegBIEN DB: mk_db: Added command...
  derived 10707 over 11 years Aaron Marcuse-Kubitza added derived/biengeo/ from https://projects.nc...
  exports 9928 over 11 years Aaron Marcuse-Kubitza added exports/_archive/
  inputs 10823 over 11 years Aaron Marcuse-Kubitza inputs/NVS/*/map.csv: Taxon Growth Form: mapped...
  lib 10835 over 11 years Aaron Marcuse-Kubitza lib/runscripts/util.run: usage: documented that...
  mappings 10722 over 11 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: mapped datasetURL
  planning 10806 over 11 years Aaron Marcuse-Kubitza planning/timeline/timeline.2013.xls: updated fo...
  schemas 10833 over 11 years Aaron Marcuse-Kubitza added schemas/postgresql*.conf.run, which insta...
  web 10836 over 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.6 KB 10539 over 11 years Aaron Marcuse-Kubitza bugfix: /Makefile: postgres-Linux: phppgadmin.c...
README.TXT 23.8 KB 10820 over 11 years Aaron Marcuse-Kubitza bugfix: /README.TXT: on a live machine, you sho...
fix_perms 97 Bytes 7560 almost 12 years Aaron Marcuse-Kubitza Added root fix_perms
map 1001 Bytes 6949 about 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 660 Bytes 10828 over 11 years Aaron Marcuse-Kubitza /run: taxon_trait/make(): order by scientificNa...
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
10836 08/30/2013 06:25 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. PostgreSQL: added info on vacuuming and analyzing.
10835 08/30/2013 06:06 PM Aaron Marcuse-Kubitza

lib/runscripts/util.run: usage: documented that this usage also applies to all files that include this file
10834 08/30/2013 06:06 PM Aaron Marcuse-Kubitza

lib/runscripts/util.run: usage: clarified that the cmd to run is a function
10833 08/30/2013 06:03 PM Aaron Marcuse-Kubitza

added schemas/postgresql*.conf.run, which installs these config files and takes care of restarting the server
10832 08/30/2013 06:02 PM Aaron Marcuse-Kubitza

added lib/runscripts/pg.conf.run, which installs PostgreSQL config files
10831 08/30/2013 06:01 PM Aaron Marcuse-Kubitza

added lib/runscripts/install.run, analogous to import.run
10830 08/30/2013 04:39 PM Aaron Marcuse-Kubitza

fix: schemas/postgresql*.conf: turn on autovacuum logging (log_autovacuum_min_duration = 0) so we can verify if autovacuum is happening
10829 08/30/2013 04:35 PM Aaron Marcuse-Kubitza

bugfix: lib/db_xml.py: put_table(): turned off db.autoanalyze, since forcing an ANALYZE after every bulk insert is inefficient for small datasources. the default autovacuum settings in schemas/postgresql.conf should be fine; however, the frequency and/or threshold may need to be increased if autovacuum does not ANALYZE frequently enough to replace db.autoanalyze.
10828 08/30/2013 03:37 PM Aaron Marcuse-Kubitza

/run: taxon_trait/make(): order by scientificName, measurementType as described in the taxon_trait table comment
10827 08/30/2013 03:36 PM Aaron Marcuse-Kubitza

lib/sh/db.sh: mk_select(): added support for ORDER BY

View all revisions | View revisions

Also available in: Atom