pgFoundry Project: PostgreSQL Loader - Releases

pgloader 2.3.2

dim@users.pgfoundry.org (Dimitri Fontaine) — Wed, 08 Jul 2009 07:36:00 GMT

Incremental update, bug fixes and little convenience feature, see changelog.

As it contains bugfixes, all users are encouraged to upgrade.

pgloader 2.3.1

dim@users.pgfoundry.org (Dimitri Fontaine) — Tue, 03 Jun 2008 12:19:00 GMT

This new version has seen some testing of max_parallel_sections setting, a user using 10 parallel sections to load a 1000 sections file. So this version saw some bugfixes too...

Version 2.3.1 also supports fixed file format, where no field separator exists but each field length is known (and fixed). This premature support does not offer any facility for stripping (left, right or both), available on user demand :)

pgloader 2.3.0

dim@users.pgfoundry.org (Dimitri Fontaine) — Mon, 10 Mar 2008 15:12:00 GMT

pgloader 2.3.0 implements parallel loading of data at several level, and comes with some minor improvements and fixes, such as the long awaited support for columns = * configuration!

Parallel loading means pgloader is now multi-threaded and able to load several sections at the same time (see the max_parallel_sections global configuration option), and has support for spreading a single file loading to several active workers threads.

See the matching documentation section for details: http://pgloader.projects.postgresql.org/#_parallel_loading

pgloader 2.2.6

dim@users.pgfoundry.org (Dimitri Fontaine) — Fri, 01 Feb 2008 10:28:00 GMT

pgloader is now able to disable triggers before loading data and to enable them when done.

Please also note the -V option now behaves sanely.

pgloader 2.2.5

dim@users.pgfoundry.org (Dimitri Fontaine) — Sat, 08 Dec 2007 20:04:00 GMT

Version 2.2.5 comes with two goodies: first, template section in configuration allows you to share any common setting in any number of sections, and second, the debian packaging is now official: pgloader will soon be part of debian repositories (process is ongoing).

pgloader 2.2.4

dim@users.pgfoundry.org (Dimitri Fontaine) — Tue, 20 Nov 2007 16:43:00 GMT

pgloader 2.2.4 implements input reformating via user provided modules and functions. A mysql module with the timestamp reformating function comes with this release, more to come if $AUTHOR hits the case or $USER asks for it :)

pgloader 2.2.3

dim@users.pgfoundry.org (Dimitri Fontaine) — Wed, 14 Nov 2007 21:10:00 GMT

pgloader now support User Defined Columns.

This allows for loading into the same database table of data coming from more than one file, keeping track of the data origin.

Simply add a column (say "origin") to the table definition and define the udc_origin option for pgloader to add a constant value per section (thus per input data file) in the database.

pgloader 2.2.2

dim@users.pgfoundry.org (Dimitri Fontaine) — Sun, 11 Nov 2007 19:51:00 GMT

This release is just a minor step forward ;)

pgloader 2.2.1

dim@users.pgfoundry.org (Dimitri Fontaine) — Thu, 23 Aug 2007 10:41:00 GMT

Answer some user requests, and change documentation format, allowing for a better project homepage!

pgloader 2.2.0

dim@users.pgfoundry.org (Dimitri Fontaine) — Mon, 04 Jun 2007 10:02:00 GMT

New version with 'real' (quoted) CSV support (two formats supported, text and csv); COPY instruction now always include target colum-list, allowing for having more columns into the table than into the data file.

Importing only some columns from the data file is also supported.