From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: database backup trouble |
Date: | 2007-02-02 14:10:12 |
Message-ID: | 45C34644.8020106@cox.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Johnson | 2007-02-02 14:11:47 | Re: Query optimization problem |
Previous Message | Dave Page | 2007-02-02 14:00:32 | Re: Query optimization problem |