pgloader activity report
Yes. This pgloader project is still maintained and somewhat active. Development happens when I receive a complaint, either about a bug in existing code or a feature in yet-to-write code. If you have a bug to report, just send me an email!
If you’re following the development of it, the sources just moved from
http://github.com/dimitri/pgloader. I will still put the
pgfoundry, and the existing binary packages maintenance should
continue. See also the
development version documentation, which contains not
yet released stuff.
This time it’s about new features, the goal being to open
without describing all the file format related details into the
pgloader.conf file. This time around,
Simon is giving feedback and told me
he would appreciate that pgloader would work more like the competition.
We’re getting there with some new options. The first one is that rather than
Sections, now your can give a
filename as an argument.
then create a configuration section for you, considering the file format to
columns = *. The default
field separator is
so you have also the
-f, --field-separator option to set that from the
As if that wasn’t enough,
pgloader now supports any
PostgreSQL option either
in the configuration file (prefix the real name with
pg_option_) or on the
command line, via the
-o, --pg-options switch, that you can use more than
once. Command line setting will take precedence over any other setup, of
course. Consider for example
While at it, some more options can now be set on the command line, including
-t, --section-threads and
-m, --max-parallel-sections on the one hand and
-r, --reject-log and
-j, --reject-data on the other hand. Those two last
must contain a
%s place holder which will get replaced by the
filename if you skipped setting up a
section for it.
Your pgloader usage is now more command line friendly than ever!