Shulou(Shulou.com)06/01 Report--

Mount the system image yum install pgloader-2.3.2-1.rhel6.x86_64.rpm

Configuration file

Conf.conf

[pgsql]

Host=192.168.245.132

Port=5432

# database

Base=postgres

User=postgres

Pass=postgres

# log_file=/home/hgs/test/t.log

Log_min_messages=INFO

# client_min_messages=log

Lc_messages= C

Client_encoding='utf-8'

# input_encoding='utf-8'

Copy_every=20000

Commit_every=20000

# copy_delimiter=%

Null= ""

Empty_string= ""

Max_parallel_sections=4

[pgloader]

Table=x

Format=text

Filename=/home/hgs/test/test_11.bcp

Field_sep=\ t

Columns=id,name

Reject_log=/home/hgs/test/test.log

Reject_data=/home/hgs/test/test.data

Execute / usr/bin/pgloader-c conf.conf-L logfile

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.