1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
|
[table_dispatcher]
job_name = table_test
src_db = dbname=scriptsrc
dst_db = dbname=scriptdst
pgq_queue_name = data.middle
logfile = sys/%(job_name)s.log
pidfile = sys/%(job_name)s.pid
# where to put data. when partitioning, will be used as base name
dest_table = data2
# date field with will be used for partitioning
# special value: _EVTIME - event creation time
part_column = start_date
#fields = *
#fields = id_pstn_cdr, foo, bar
#fields = id_pstn_cdr:my_id, foo, bar:baz
# template used for creating partition tables
# _DEST_TABLE
part_template =
create table _DEST_TABLE () inherits (data2);
|