| 1 | 0] Precondition: current folder, containing init_db.sql and curves2db.R |
| 2 | must be readable by the postgres user (some other weird restrictions ...) |
| 3 | |
| 4 | 1] Initialization: |
| 5 | a) log in as postgres user: |
| 6 | sudo -i -u postgres |
| 7 | b) launch PostgreSQL shell: |
| 8 | psql |
| 9 | c) execute init script: |
| 10 | \i /path/to/init_db.sql |
| 11 | |
| 12 | 2] Launch DB-filling script: |
| 13 | a) check/tune parameters at the beginning of curves2db.R |
| 14 | b) run the script |
| 15 | |
| 16 | ===== |
| 17 | |
| 18 | WARNING: very slow for large datasets |
| 19 | |
| 20 | read_db.R: example usage to read curves from DB |