Re: pg_upgrade defaulting to port 25432 - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: pg_upgrade defaulting to port 25432
Date
Msg-id 201106242347.p5ONlNS19392@momjian.us
Whole thread Raw
In response to Re: pg_upgrade defaulting to port 25432  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: pg_upgrade defaulting to port 25432
Re: pg_upgrade defaulting to port 25432
List pgsql-hackers
Peter Eisentraut wrote:
> On fre, 2011-06-24 at 16:34 -0400, Bruce Momjian wrote:
> > > > It also creates two new environment variables,
> > > > OLDPGPORT and NEWPGPORT, to control the port values because we
> > don't
> > > > want to default to PGPORT anymore.
> > > 
> > > I would prefer that all PostgreSQL-related environment variables
> > start
> > > with "PG".
> > 
> > OK, attached.  I was also using environment variables for PGDATA and
> > PGBIN do I renamed those too to begin with 'PG'.
> 
> I'm wondering why pg_upgrade needs environment variables at all.  It's a
> one-shot operation.  Environment variables are typically used to shared
> default settings across programs.  I don't see how that applies here.

They were there in the original EnterpriseDB code, and in some cases
like PGPORT, we _used_ those environment variables.  Also, the
command-line can get pretty long so we actually illustrate environment
variable use in its --help:
For example:  pg_upgrade -d oldCluster/data -D newCluster/data -b oldCluster/bin -B newCluster/binor  $ export
OLDDATADIR=oldCluster/data $ export NEWDATADIR=newCluster/data  $ export OLDBINDIR=oldCluster/bin  $ export
NEWBINDIR=newCluster/bin $ pg_upgrade
 

You want the environment variable support removed?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +


pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: Deriving release notes from git commit messages
Next
From: karavelov@mail.bg
Date:
Subject: Re: FWD: fastlock+lazyvzid patch performance