-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 02/02/07 06:01, Tomi N/A wrote: > I'm trying to set up an automatic backup mechanism and have a number > of questions about issues I've encountered. > First of all, I tried to install pgAgent (the server is running win2k3 > and pgsql 8.1.5). Trying to start the pgagent service results in an [snip] > pg_dump -h localhost -U myuser mydatabase -f outputfile.backup > The same command executed from a beanshell script (I wanted to be > platform independent) does nothing. > > Where I stand at the moment: > 1.) obviously, the beanshell solution will do nothing for me until I > find out why I can't execute a windows scheduled task, but it might be > a fairly flexible workarround if corrected > 2.) again, obviously, I'd much, much rather do the backup from > pgAgent, if anyone can tell me how I can get arround the error Windows > throws at me. Did I miss it, or are you saying that the database is hosted on a win2k3 box? Are you also saying that you are running the pg_dump command from the "console" of the machine that is hosting the database? -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFFw0ZES9HxQb37XmcRAmY1AJ9fn795qH2sQdmZLSl/hPAwdjXqrwCfUZVb RSR+Jqp+CknlaBnKayCRWXQ= =64wU -----END PGP SIGNATURE-----