Re: Using pg_upgrade on log-shipping standby servers

On 07/26/2012 09:59 AM, Peter Eisentraut wrote:
>> I think I could create a list and pass that into a loop so only
>> the command has to be modified, but again, how do we do that on Windows?
>> Can we create a shell function in Windows and pass the file name as an
>> argument?
> I don't know, but I assume that somewhere in the known universe there is
> a way on Windows to say, here is a list of files, copy them to that
> host.


The issue isn't whether or not there is a way known somewhere in the 
universe to do something, it's whether or not it's reasonable to assume 
that such a thing is likely to be available. In general we have tried 
not to assume very much at all about what's available on Windows - not 
much beyond the simple cmd.exe shell.

On Windows I typically use scp to copy things around between machines, 
but I'd be very wary of creating a Postgres utility that expects it to 
be present.

cheers

andrew