Re: Resurrecting pg_upgrade

Tom Lane wrote:

> "Marc G. Fournier" <scrappy@postgresql.org> writes:
>> Then again, in the case of pg_upgrade, wouldn't just disabling access from
>> anywhere except localhost prevent others from getting in?
> 
> Not if your normal operating mode includes connections from clients
> running locally.  I really don't see any clean way to ensure that
> pg_upgrade (and subsidiary pg_dump runs invoked by it) are the only
> ones allowed to connect to the database, if we keep the normal
> postmaster running.  But if we shut down the postmaster then it's
> trivial.

If you want to prevent "accidential" access, start postmaster on a 
non-standard port.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #