You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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)
The text was updated successfully, but these errors were encountered:
(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!
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)
The text was updated successfully, but these errors were encountered: