Thread: BUG #2484: pg_dump not support < redirect

The following bug has been logged online:

Bug reference:      2484
Logged by:          Yu-Lung Shao
Email address:      allen_shao@seed.net.tw
PostgreSQL version: 8.1.4-1
Operating system:   WinXP Home
Description:        pg_dump not support < redirect
Details:

file: backup.cmd

pg_dump.exe dbname -U postgres -W -f dbname.sql <
password.txt

in 8.0.3 is work

in 8.1.4 is not work need manual key in password.

> Bug reference:      2484
> Logged by:          Yu-Lung Shao
> Email address:      allen_shao@seed.net.tw
> PostgreSQL version: 8.1.4-1
> Operating system:   WinXP Home
> Description:        pg_dump not support < redirect
> Details:=20
>=20
> file: backup.cmd=20
>=20
> pg_dump.exe dbname -U postgres -W -f dbname.sql < password.txt
>=20
> in 8.0.3 is work
>=20
> in 8.1.4 is not work need manual key in password.

The bug is in 8.0.3 (and <=3D 8.1.3 as well), fixed in the latest
versions. If you want to pass the password to pg_dump, use pgpass.conf
or the PGPASSWORD environment variable.

//Magnus