Is it possible somehow to run the postgres batch tool pg_bulkload on windows? I could not find any documentation on this, only for linux.

Though it should be possible as the docs state:

If you use pg_bulkload in Windows operating system, postgresql script is not included in a pg_bulkload package. So you have to invoke "pg_bulkload -r" manually.

Finally it should be triggered from inside a java tool, which itself also has to run on the same machine.

  • From what I see on the project page, this product is not extremely stable (see the notes about 3.1.7). Are you sure the regular COPY functionality is not enough for you? – dezso May 6 '15 at 12:44
  • Well, it depends wether the import using pg_bulkload would be much faster than COPY. The docs suggest improvements of about 50%, which would be enough for me to make the switch. – membersound May 6 '15 at 14:15
  • How much data do you import normally (in number of rows and/or physical size)? On an other note, if it crashes your server than you don't get too far with the time spared on the load. – dezso May 6 '15 at 14:21
  • It's about 300mio rows and 150 GB, 2-3 times a day. Yes, probably you're right it won't give me much improvement if I'd have to worry about stability all the time... – membersound May 6 '15 at 14:23
  • 1
    Then I understand why you are concerned about time :) – dezso May 6 '15 at 14:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.