could not establish connection to parallel writer

[GargantuarZuo]

I've set my postgresql 10 to 'without the need for a password' mode ,and can log on to the DB only with 'psql -d posteva -h localhost -p 5432 -U postgres' command. However, when I use pg_bulkloader(VERSION 3.1.14) with the command 'pg_bulkload -d posteva -h localhost -p 5432 -U postgres -w ./bulkload_raw_uemr.ctl', an error occured like this.

PS: When I use VERSION 3.1.13 with the same cmd on PG9.6, there's nothing wrong. Is there any problem with my way of using new version pg_bulkload?

ERROR: query failed: ERROR: could not establish connection to parallel writer DETAIL: could not translate host name "." to address: Name or service not known

HINT: Refer to the following if it is an authentication error. Specifies the authentication method to without the need for a password in pg_hba.conf (ex. trust or ident), or specify the password to the password file of the operating system user who ran PostgreSQL server. If cannot use these solution, specify WRITER=DIRECT. DETAIL: query was: SELECT * FROM pg_bulkload($1)

[MoonInsung]

Dear GargantuarZuo .

Thank you for sharing problem. But..I can't reproduce the problem your mentioned.

So please share the details(Spec) of the problem below.

1. CTL file(Control file)
2. state of db table(\d+ tablename)
3. output of pg_bulkload --version
4. output of postgres --version
5. output of \ df

Regards. Moon.

[GargantuarZuo]

@MoonInsung Dear MoonInsung, Thank you for your early reply. The details you need is shown below:

(1)ctl file: `#

sample_csv.ctl -- Control file to load CSV input data

Copyright (c) 2007-2011, NIPPON TELEGRAPH AND TELEPHONE CORPORATION

[<schema_name>.]table_name

OUTPUT = raw_uemr_bk_test #FILTER=eva_filter_do_bulkload_to_5s_uemr

database action

TRUNCATE=NO ON_DUPLICATE_KEEP = NEW

Input data location (absolute path)

INPUT = /data1/posteva/csv.data/mxdruemr/2017.07.12.15.00.00/MXDR_UEMR-20170712150000-000-17.txt LOGFILE=/software/bulkloader10test/raw_uemr.log PARSE_BADFILE=/software/bulkloader10test/raw_uemr.bad.log DUPLICATE_BADFILE=/software/bulkloader10test/raw_uemr.duplicate.log

Input file type

TYPE = CSV

CSV Fomart Parameters

QUOTE = """ ESCAPE =
DELIMITER = "|" NULL=""

SKIP=0 LIMIT=INFINITE PARSE_ERRORS=INFINITE DUPLICATE_ERRORS=INFINITE

WRITER=PARALLEL VERBOSE =NO`

(2)state of db table(\d+ tablename) I'm not quite sure what exactly the command is, and whether it could be excuted directly by shell or by the postgresql command.

(3)output of pg_bulkload --version pg_bulkload 3.1.14

(4)output of postgres --version postgres (PostgreSQL) 10.0

(5)output of \ df I'm not quite sure what exactly the command is, and whether it could be excuted directly by shell or by the postgresql command.

If you need any more information, please let me know. Thank you!