how to fix it ?

[huicpc0215]

INFO[20161218 04:11:25] [ main.go ] 37 [ ---------------------------------------------------------->>>
INFO[20161218 04:11:25] [ main.go ] 38 trading broker Engine V1.1 postgres
INFO[20161218 04:11:25] [ main.go ] 39 <<<----------------------------------------------------------]
INFO[20161218 04:11:25] [ trade_center.go ] 49 unit_min_amount,unit_max_amount: 0.01 5
ERRO[20161218 04:11:25] [ db.go ] 49 open: pq: password authentication failed for user "root"
ERRO[20161218 04:11:25] [ trade_order.go ] 88 pq: password authentication failed for user "root"
INFO[20161218 04:11:25] [ amount_limit.go ] 40 init limit: 200 200 0 0
INFO[20161218 04:11:25] [ amount_limit.go ] 123 buy_total_amount: 0
INFO[20161218 04:11:25] [ amount_limit.go ] 132 sell_total_amount: 0
ERRO[20161218 04:11:25] [ db.go ] 49 open: pq: password authentication failed for user "root"
ERRO[20161218 04:11:25] [ exchange_config.go ] 55 pq: password authentication failed for user "root"
INFO[20161218 04:11:25] [ trade_server.go ] 48 Thrift server listening on 127.0.0.1:18030
ERRO[20161218 04:11:26] [ db.go ] 49 open: pq: password authentication failed for user "root"
ERRO[20161218 04:11:26] [ tx.go ] 11 pq: password authentication failed for user "root"
ERRO[20161218 04:11:26] [ tx.go ] 36 TxBegin failed pq: password authentication failed for user "root"
ERRO[20161218 04:11:27] [ db.go ] 49 open: pq: password authentication failed for user "root"

endless.. error.
And how can I use postgres sql?

[philsong]

you need config correct postgresql user and password account.

[huicpc0215]

Right now, I have use root:root to postgre sql.
When I import sql from trader_2016_06_29.sql,
it shows that psql:etc/trader_2016_06_29.sql:733: ERROR: role "phil" does not exist.
When I create user phil, It shows that:

psql:etc/trader_2016_06_29.sql:23: ERROR: must be owner of extension plpgsql
SET
SET
SET
psql:etc/trader_2016_06_29.sql:47: ERROR: relation "account" already exists
psql:etc/trader_2016_06_29.sql:50: ERROR: must be owner of relation account
psql:etc/trader_2016_06_29.sql:61: ERROR: relation "account_id_seq" already exists
psql:etc/trader_2016_06_29.sql:64: ERROR: must be owner of relation account_id_seq
psql:etc/trader_2016_06_29.sql:70: ERROR: must be owner of relation account_id_seq
psql:etc/trader_2016_06_29.sql:84: ERROR: relation "amount_config" already exists
psql:etc/trader_2016_06_29.sql:87: ERROR: must be owner of relation amount_config
psql:etc/trader_2016_06_29.sql:98: ERROR: relation "amount_config_id_seq" already exists
psql:etc/trader_2016_06_29.sql:101: ERROR: must be owner of relation amount_config_id_seq
psql:etc/trader_2016_06_29.sql:107: ERROR: must be owner of relation amount_config_id_seq
psql:etc/trader_2016_06_29.sql:121: ERROR: relation "depth" already exists
psql:etc/trader_2016_06_29.sql:124: ERROR: must be owner of relation depth

How can I fix it?

[huicpc0215]

I found that it's not easy to setup property to import postgresql file.

[philsong]

replace the username to your real db username in sql file.