Re: Using pg_upgrade on log-shipping standby servers - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Using pg_upgrade on log-shipping standby servers
Date
Msg-id 50115400.6040402@dunslane.net
Whole thread Raw
In response to Re: Using pg_upgrade on log-shipping standby servers  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Using pg_upgrade on log-shipping standby servers
Next
From: Bruce Momjian
Date:
Subject: Re: Using pg_upgrade on log-shipping standby servers