File: table.ini

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 (29 lines) | stat: -rw-r--r-- 671 bytes parent folder | download | duplicates (4)
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);