Re: Fw: Running config vars

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Jim Buttafuoco <jim(at)tylerdrive(dot)org>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fw: Running config vars
Date: 2001-05-16 17:17:13
Message-ID: 200105161717.f4GHHEu18167@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


I think the way to do this is for SHOW ALL to show all setttings.

[ Charset ISO-8859-1 unsupported, converting... ]
>
> Hi all (I hope this is the correct list),
>
> Under Oracle there is v$parameter which list ALL config varables. Under
> psql there is the SHOW command, but this only lists 1 variable. I have
> written a shell script (attached) that shows ALL know variables. My
> questions is can this script get included under contrib directory and is
> there a way to make it into a view. I believe this kind of info will
> help in trouble shooting problems.
>
> thanks
> Jim
>
>
>
>
>
>

[ application/octet-stream is not supported, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim Buttafuoco 2001-05-16 17:20:40 Re: Fw: Running config vars
Previous Message Peter Eisentraut 2001-05-16 17:15:47 Re: Configurable path to look up dynamic libraries