Re: pg_upgrade using appname to lock out other users - Mailing list pgsql-hackers

From Christopher Browne
Subject Re: pg_upgrade using appname to lock out other users
Date
Msg-id BANLkTimcmTL8pDEPDgNyem8PogrjRjrDGQ@mail.gmail.com
Whole thread Raw
In response to Re: pg_upgrade using appname to lock out other users  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
On Thu, Jun 16, 2011 at 1:48 PM, Bruce Momjian <bruce@momjian.us> wrote:
> Tom Lane wrote:
>> "Ross J. Reedstrom" <reedstrm@rice.edu> writes:
>> > As an operations guy, the idea of an upgrade using a random,
>> > non-repeatable port selection gives me the hebejeebees.
>>
>> Yeah, I agree.  The latest version of the patch doesn't appear to have
>> any random component to it, though --- it just expects the user to
>> provide port numbers as switches.
>
> Oh, you wanted pg_upgrade to pick a random port number?  I can do that,
> but how would it check to see it is unused?

If no port is specified, that *might* be a reasonable behavior, but it
certainly throws in a dose of the wrong sort of nondeterminism, hence
heebie-jeebies...
--
When confronted by a difficult problem, solve it by reducing it to the
question, "How would the Lone Ranger handle this?"


pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: Patch - Debug builds without optimization
Next
From: Alexey Klyukin
Date:
Subject: Re: proposal: a validator for configuration files