Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: strange issue with the Postgres Bulk Loader

  1. #1
    Join Date
    Sep 2007
    Posts
    834

    Default strange issue with the Postgres Bulk Loader

    Hi, we have the following issue.
    We have an Amazon instance with Postgres 9.3 and PDI 6, and we want to run a simple transformation that loads data into a table in Postgres.

    When we run the ktr with Pan in the server, the process starts and then we are prompt for the Postgres password. After we type the password, the ktr continues and ends without error.

    The same ktr against the same Postgres instance runs without problem from a local machine: Ubuntu 14.0.4. There is no need to enter the password manually, which is the expected behavior.
    Also, replacing the Bulk Loader with a Table Output works fine in the server, but we don't want this as a solution.


    Any ideas?
    Thanks in advance.

  2. #2
    Join Date
    Jul 2009
    Posts
    476

    Default

    Others here have had questions about the Postgres Bulk Loader, and I've responded to several of them:

    https://www.google.com/webhp?sourcei...ms.pentaho.com

    Make sure your pgpass file is set up correctly on the server where you want to run the transformation. The pgpass file is documented here: http://www.postgresql.org/docs/curre...pq-pgpass.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.