File: bulk_loader.ini.templ

package info (click to toggle)
skytools 2.1.8-2.2
  • links: PTS, VCS
  • area: main
  • in suites: squeeze
  • size: 1,980 kB
  • ctags: 1,543
  • sloc: sql: 6,635; python: 6,237; ansic: 2,799; makefile: 308; sh: 268
file content (24 lines) | stat: -rw-r--r-- 425 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
 
[bulk_loader]
job_name = bizgres_loader

src_db = dbname=bulksrc
dst_db = dbname=bulkdst

pgq_queue_name = xx

use_skylog = 1

logfile = ~/log/%(job_name)s.log
pidfile = ~/pid/%(job_name)s.pid

# 0 - apply UPDATE as UPDATE
# 1 - apply UPDATE as DELETE+INSERT
# 2 - merge INSERT/UPDATE, do DELETE+INSERT
load_method = 0

# no hurry
loop_delay = 10

# table renaming
# remap_tables = skypein_cdr_closed:skypein_cdr, tbl1:tbl2