Re: database backup trouble - Mailing list pgsql-general

From Ron Johnson
Subject Re: database backup trouble
Date
Msg-id 45C34644.8020106@cox.net
Whole thread Raw
In response to database backup trouble  ("Tomi N/A" <hefest@gmail.com>)
List pgsql-general
-----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-----

pgsql-general by date:

Previous
From: Dave Page
Date:
Subject: Re: Query optimization problem
Next
From: Ron Johnson
Date:
Subject: Re: Query optimization problem