Skip to content
High speed data loading utility for PostgreSQL
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
SPECS Fixed prologue comments for SPEC file(version information) Jan 18, 2019
bin Remove unnecessary regresstion tests code Feb 28, 2019
docs Update copryright for 2019 Jan 18, 2019
include
lib Update copryright for 2019 Jan 18, 2019
msvc Create STABLE branch of pg_bulkload 3.1.x Oct 31, 2013
util Fixed pg_bulk to mitigate attacks described in CVE-2018-1058 Oct 1, 2018
.gitignore
.travis.yml Fix Travis build to use correct PG branch Jul 5, 2018
COPYRIGHT
Makefile Update copryright for 2019 Jan 18, 2019
README.md

README.md

pg_bulkload

pg_bulkload is a high speed data loading tool for PostgreSQL.

pg_bulkload is designed to load huge amount of data to a database. You can load data to table bypassing PostgreSQL shared buffers.

pg_bulkload also has some ETL features; input data validation and data transformation.

Branches

  • master : branch for pg_bulkload 3.1 Build Status
  • VERSION3_2_DEV : branch for pg_bulkload 3.2 Build Status

How to use

pg_bulkload works with control file like below,

$ pg_bulkload sample_csv.ctl
NOTICE: BULK LOAD START
NOTICE: BULK LOAD END
	0 Rows skipped.
	8 Rows successfully loaded.
	0 Rows not loaded due to parse errors.
	0 Rows not loaded due to duplicate errors.
	0 Rows replaced with new rows.

See documentation about detail usage.

http://ossc-db.github.io/pg_bulkload/index.html

How to build and install from source code

Change directory into top directory of pg_bulkload sorce codes and run the below commands.

 $ make
 # make install

How to run regression tests

Start PostgreSQL server and run the below command.

 $ make installcheck
You can’t perform that action at this time.