Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

could not establish connection to parallel writer #64

Open
GargantuarZuo opened this issue Nov 14, 2017 · 2 comments
Open

could not establish connection to parallel writer #64

GargantuarZuo opened this issue Nov 14, 2017 · 2 comments
Assignees

Comments

@GargantuarZuo
Copy link

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
Copy link
Contributor

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
Copy link
Author

@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!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants