Обсуждение: Scripting issue
I am trying to script a pg_dumpall command set to use in a crontab entry. The problem I am finding is that the command pg_dumpall seems to be ignoring the -W input.=20 (I get password prompts on all 4 instances within the DB.)=20=20=20=20 It is happening on a Oracle Enterprise Linux 5 server and PostgreSQL 8.3.5 as well as 8.3.7 Please help. -Scott D. Scott Wells=20=20 Systems Administrator II Apollo Group Inc.=20 STS | 4325 S. 30th Street | Suite 200 | M/S AA-M002 | Phoenix, AZ 85040 (602) 557.6673 This message is private and confidential. If you have received it in error,= please notify the sender and remove it from your system.=
On Mon, Apr 20, 2009 at 11:08:56AM -0700, Scott Wells wrote: > I am trying to script a pg_dumpall command set to use in a crontab > entry. > The problem I am finding is that the command pg_dumpall seems to be > ignoring the -W input. not sure what you mean by -W input. -W is a switch to force tools to ask for password. > (I get password prompts on all 4 instances within the DB.) > It is happening on a Oracle Enterprise Linux 5 server and PostgreSQL > 8.3.5 as well as 8.3.7 use pgpass file, as described in here: http://www.postgresql.org/docs/current/interactive/libpq-pgpass.html Best regards, depesz -- Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/ jid/gtalk: depesz@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007