X-Git-Url: https://git.auder.net/?p=epclust.git;a=blobdiff_plain;f=data%2Fcurves_to_db%2FREADME;fp=data%2Fcurves_to_db%2FREADME;h=5a13a26704853a5212f6ef939aae8baf18bae4d4;hp=0000000000000000000000000000000000000000;hb=e906736ea27105237e84c904dce6170353726292;hpb=57f337af19cd6251815bb1ff2d62f4c58e8b6078 diff --git a/data/curves_to_db/README b/data/curves_to_db/README new file mode 100644 index 0000000..5a13a26 --- /dev/null +++ b/data/curves_to_db/README @@ -0,0 +1,20 @@ +0] Precondition: current folder, containing init_db.sql and curves2db.R + must be readable by the postgres user (some other weird restrictions ...) + +1] Initialization: + a) log in as postgres user: + sudo -i -u postgres + b) launch PostgreSQL shell: + psql + c) execute init script: + \i /path/to/init_db.sql + +2] Launch DB-filling script: + a) check/tune parameters at the beginning of curves2db.R + b) run the script + +===== + +WARNING: very slow for large datasets + +read_db.R: example usage to read curves from DB