Re: PITR on Win32 - Archive and Restore

From: "Gary Doades" <gpd(at)gpdnet(dot)co(dot)uk>
To: pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: PITR on Win32 - Archive and Restore
Date: 2004-08-09 08:31:08
Message-ID: 4117445C.860.20BD9876@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers-win32 pgsql-patches

On 9 Aug 2004 at 20:12, markir(at)coretech(dot)co(dot)nz wrote:

> I *think* I have tried that one, but checked anyway:
>
> The result is :
>
> LOG: archive command ""copy
> "c:/databases/pgdata/pg_xlog/000000010000000000000000"
> "c:/databases/pgarchive/000000010000000000000000""" failed: return code 1
> The system cannot find the file specified.
>
> I think this led us on to more bizzare pastures...
>

The problem here is that "Copy" is not an external command (as it
says), but it is built into the "shell" (cmd.exe). To use copy you would
have to run cmd.exe and make the copy command the first parameter
after the /C switch.

It's much better to use "xcopy" anyway, which *is* an external command
and can be run with a string similar to the one use are using now.

Cheers,
Gary.

In response to

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Merlin Moncure 2004-08-09 12:12:29 Re: PITR on Win32 - Archive and Restore
Previous Message markir 2004-08-09 08:28:09 Re: PITR on Win32 - Archive and Restore

Browse pgsql-patches by date

  From Date Subject
Next Message Gaetano Mendola 2004-08-09 09:46:45 Re: psql - missing tab-completion support for tablespaces
Previous Message markir 2004-08-09 08:28:09 Re: PITR on Win32 - Archive and Restore