Re: [HACKERS] Make pg_regress print a connstring with sockdir - Mailing list pgsql-hackers

From Craig Ringer
Subject Re: [HACKERS] Make pg_regress print a connstring with sockdir
Date
Msg-id CAMsr+YEukaJMUe7mNNRV+D-hGT0KxURBi2r2a5MuhAFonWbYfg@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Make pg_regress print a connstring with sockdir  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] Make pg_regress print a connstring with sockdir  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers

On 28 August 2017 at 19:45, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Craig Ringer <craig@2ndquadrant.com> writes:
> It's a pain having to find the postmaster command line to get the port
> pg_regress started a server on. We print the port in the pg_regress output,
> why not the socket directory / host?

I'm not following the point here.  The test postmaster isn't really
going to be around long enough to connect to it manually.  If you
want to do that, you should be using "installcheck", and then the
problem doesn't arise.

The reason for printing the port number, if memory serves, is to
aid in debugging port selection conflicts.  That doesn't really
apply for temporary socket directories; we're expecting libc to
avoid any conflicts there.

I'm frequently debugging postmasters that are around long enough. Deadlocks, etc.

It's also way easier to debug shmem related issues with a live postmaster vs a core.

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Make pg_regress print a connstring with sockdir
Next
From: Michael Paquier
Date:
Subject: Re: [HACKERS] standby server crashes hard on out-of-disk-space in HEAD