search

ossc-db / pg_bulkload

High speed data loading utility for PostgreSQL
http://ossc-db.github.io/pg_bulkload/index.html
Other
437 stars 75 forks source link

Errors when making installcheck #165

Open cquheiha opened 2 weeks ago

cquheiha commented 2 weeks ago

In the file regression.diffs, there are many errors like this:

\! pg_bulkload -d contrib_regression data/bin1.ctl -i data/data1.bin -l results/bin1.log -P results/bin1.prs -u results/bin1.dup
  NOTICE: BULK LOAD START
! ERROR: query failed: ERROR:  could not open data file: No such file or directory
! DETAIL: query was: SELECT * FROM pgbulkload.pg_bulkload($1)
  \! awk -f data/adjust.awk results/bin1.log

In the file bin1.log, INPUT, PARSE_BADFILE and LOGFILE are all correct:

INPUT = /home/postgres/polardb_pg/contrib/pg_bulkload-3.1.20/bin/data/data1.bin
PARSE_BADFILE = /home/postgres/polardb_pg/contrib/pg_bulkload-3.1.20/bin/results/bin1.prs
LOGFILE = /home/postgres/polardb_pg/contrib/pg_bulkload-3.1.20/bin/results/bin1.log

The data files can be found in the above directory, but errors happend when I make installcheck.

shinyaaa commented 2 weeks ago

Could you please tell me how to install and what is the directory structure?

shinyaaa commented 2 weeks ago

Is there a path to pg_config? If not, you can run

  1. make USE_PGXS=1 PG_CONFIG=/path/to/pg_config
  2. make USE_PGXS=1 PG_CONFIG=/path/to/pg_config install
  3. make USE_PGXS=1 PG_CONFIG=/path/to/pg_config installcheck