On Fri, May 16, 2014 at 08:34:09PM +0000, derek_ealy(at)rapid7(dot)com wrote:
> When exec'ing a command to pg_dump or psql from Java there is no "normal"
> way to send the password to the psql process.
>
> On Linux systems it works as expected because I write the password to the
> input stream of the process running psql.
Normal way of providing password is either to use PGPASSWORD environment
variable, as shown here:
http://www.postgresql.org/docs/current/interactive/libpq-envars.html
or pgpass file, as shown here:
http://www.postgresql.org/docs/current/interactive/libpq-pgpass.html
depesz