Skip site navigation (1) Skip section navigation (2)

Exposing an installation's default value of unix_socket_directory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: Exposing an installation's default value of unix_socket_directory
Date: 2010-10-21 18:07:25
Message-ID: 27500.1287684445@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
I just noticed that there doesn't seem to be any good way of finding
out what a postmaster's default value of unix_socket_directory is.
If you try to SHOW it you just get an empty string.  We could probably
fix things so that SHOW exposes the actual setting, but (1) there might
be security arguments against that, and (2) if your problem is that you
would like to find out the value so's you can connect to said
postmaster, SHOW isn't going to help you.

One possible response would be to add an item to what pg_config knows
about, eg "pg_config --socketdir".  This doesn't answer every possible
use-case either, but it would be helpful for some scenarios.

Thoughts?

			regards, tom lane

Responses

pgsql-hackers by date

Next:From: Greg StarkDate: 2010-10-21 18:10:35
Subject: Re: UNION ALL has higher cost than inheritance
Previous:From: Bruce MomjianDate: 2010-10-21 18:06:08
Subject: Re: [JDBC] Support for JDBC setQueryTimeout, et al.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group