Re: Support custom socket directory in pg_upgrade - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Support custom socket directory in pg_upgrade
Date
Msg-id 20181123140712.72gv6czx7jrflnkx@alvherre.pgsql
Whole thread Raw
In response to Re: Support custom socket directory in pg_upgrade  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Support custom socket directory in pg_upgrade
List pgsql-hackers
On 2018-Nov-12, Tom Lane wrote:

> Peter Eisentraut <peter.eisentraut@2ndquadrant.com> writes:
> > On 12/11/2018 20:00, Tom Lane wrote:
> >> Also, even if we had an arguably-better idea, I suspect that there would
> >> always be cases where it didn't work.  For example, one idea is to make
> >> a temporary directory under the installation's normal socket directory
> >> (thus, /tmp/pgXXXX/ or some such).  But, if the normal socket directory
> >> is not /tmp, we might find that pg_upgrade can't write there.
> 
> > We do exactly that in pg_regress and it's never been a problem.
> 
> Yeah, but pg_upgrade is used by a much wider variety of people
> than pg_regress.

Surely they can just set TMPDIR if /tmp is not writable?  If TMPDIR is
set and not writable, bark at the user for it.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-hackers by date:

Previous
From: Rushabh Lathia
Date:
Subject: Re: Hitting CheckRelationLockedByMe() ASSERT with force_generic_plan
Next
From: Sergey Cherkashin
Date:
Subject: Re: Psql patch to show access methods info