Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f4ICdAA32812 for ; Fri, 18 May 2001 08:39:10 -0400 (EDT) (envelope-from pgsql-hackers-owner@postgresql.org) Received: from p2.buttafuoco.net (buttafuoco.mv.com [207.22.43.121]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4GGrfA73535 for ; Wed, 16 May 2001 12:53:42 -0400 (EDT) (envelope-from jim@buttafuoco.net) Received: (from nobody@localhost) by p2.buttafuoco.net (8.9.3/8.9.3) id MAA03860; Wed, 16 May 2001 12:53:33 -0400 Date: Wed, 16 May 2001 12:53:33 -0400 Message-Id: <200105161653.MAA03860@p2.buttafuoco.net> X-Authentication-Warning: p2.buttafuoco.net: nobody set sender to jim@buttafuoco.net using -f From: "Jim Buttafuoco" To: pgsql-hackers@postgresql.org Subject: Running config vars X-Mailer: NeoMail 1.24 X-IPAddress: 207.22.43.154 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=NEOMAIL_ATT_0.111011637374759" X-Archive-Number: 200105/719 X-Sequence-Number: 8960 This is a multi-part message in MIME format. ------=NEOMAIL_ATT_0.111011637374759 Content-Type: text/plain; charset=iso-8859-1 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 ------=NEOMAIL_ATT_0.111011637374759 Content-Type: application/octet-stream; name="pg_conf" Content-Transfer-Encoding: base64 cHNxbCAtcSB0ZW1wbGF0ZTEgPDxfX0VPUV9fICAyPiYxIHwgZ3JlcCAnTk9U SUNFOicgfCBzZWQgLWUgJ3MvTk9USUNFOiAgLy9nJyAtZSAncy8gaXMgLz0v JwpzaG93IHRjcGlwX3NvY2tldCA7CnNob3cgc3NsIDsKc2hvdyBtYXhfY29u bmVjdGlvbnMgOwpzaG93IHBvcnQgOwpzaG93IGhvc3RuYW1lX2xvb2t1cCA7 CnNob3cgc2hvd19zb3VyY2VfcG9ydCA7CnNob3cgdW5peF9zb2NrZXRfZGly ZWN0b3J5IDsKc2hvdyB1bml4X3NvY2tldF9ncm91cCA7CnNob3cgdW5peF9z b2NrZXRfcGVybWlzc2lvbnMgOwpzaG93IHZpcnR1YWxfaG9zdCA7CnNob3cg a3JiX3NlcnZlcl9rZXlmaWxlIDsKc2hvdyBzb3J0X21lbSA7CnNob3cgc2hh cmVkX2J1ZmZlcnMgOwpzaG93IGZzeW5jIDsKc2hvdyBlbmFibGVfc2Vxc2Nh biA7CnNob3cgZW5hYmxlX2luZGV4c2NhbiA7CnNob3cgZW5hYmxlX3RpZHNj YW4gOwpzaG93IGVuYWJsZV9zb3J0IDsKc2hvdyBlbmFibGVfbmVzdGxvb3Ag OwpzaG93IGVuYWJsZV9tZXJnZWpvaW4gOwpzaG93IGVuYWJsZV9oYXNoam9p biA7CnNob3cga3NxbyA7CnNob3cgZ2VxbyA7CnNob3cgZWZmZWN0aXZlX2Nh Y2hlX3NpemUgOwpzaG93IHJhbmRvbV9wYWdlX2Nvc3QgOwpzaG93IGNwdV90 dXBsZV9jb3N0IDsKc2hvdyBjcHVfaW5kZXhfdHVwbGVfY29zdCA7CnNob3cg Y3B1X29wZXJhdG9yX2Nvc3QgOwpzaG93IGdlcW9fc2VsZWN0aW9uX2JpYXMg OwpzaG93IGdlcW9fdGhyZXNob2xkIDsKc2hvdyBnZXFvX3Bvb2xfc2l6ZSA7 CnNob3cgZ2Vxb19lZmZvcnQgOwpzaG93IGdlcW9fZ2VuZXJhdGlvbnMgOwpz aG93IGdlcW9fcmFuZG9tX3NlZWQgOwpzaG93IHNxbF9pbmhlcml0YW5jZSA7 CnNob3cgZGVhZGxvY2tfdGltZW91dCA7CnNob3cgbWF4X2V4cHJfZGVwdGgg OwpzaG93IHdhbF9idWZmZXJzIDsKc2hvdyB3YWxfZmlsZXMgOwpzaG93IHdh bF9zeW5jX21ldGhvZCA7CnNob3cgd2FsX2RlYnVnIDsKc2hvdyBjb21taXRf ZGVsYXkgOwpzaG93IGNvbW1pdF9zaWJsaW5ncyA7CnNob3cgY2hlY2twb2lu dF9zZWdtZW50cyA7CnNob3cgY2hlY2twb2ludF90aW1lb3V0IDsKc2hvdyBz aWxlbnRfbW9kZSA7CnNob3cgbG9nX2Nvbm5lY3Rpb25zIDsKc2hvdyBsb2df dGltZXN0YW1wIDsKc2hvdyBsb2dfcGlkIDsKc2hvdyBkZWJ1Z19sZXZlbCA7 CnNob3cgZGVidWdfcHJpbnRfcXVlcnkgOwpzaG93IGRlYnVnX3ByaW50X3Bh cnNlIDsKc2hvdyBkZWJ1Z19wcmludF9yZXdyaXR0ZW4gOwpzaG93IGRlYnVn X3ByaW50X3BsYW4gOwpzaG93IGRlYnVnX3ByZXR0eV9wcmludCA7CnNob3cg ZGVidWdfYXNzZXJ0aW9ucyA7CnNob3cgc3lzbG9nIDsKc2hvdyBzeXNsb2df ZmFjaWxpdHkgOwpzaG93IHN5c2xvZ19pZGVudCA7CnNob3cgc2hvd19wYXJz ZXJfc3RhdHMgOwpzaG93IHNob3dfcGxhbm5lcl9zdGF0cyA7CnNob3cgc2hv d19leGVjdXRvcl9zdGF0cyA7CnNob3cgc2hvd19xdWVyeV9zdGF0cyA7CnNo b3cgc2hvd19idHJlZV9idWlsZF9zdGF0cyA7CnNob3cgdHJhY2Vfbm90aWZ5 IDsKc2hvdyB0cmFjZV9sb2NrcyA7CnNob3cgdHJhY2VfdXNlcmxvY2tzIDsK c2hvdyB0cmFjZV9zcGlubG9ja3MgOwpzaG93IGRlYnVnX2RlYWRsb2NrcyA7 CnNob3cgdHJhY2VfbG9ja19vaWRtaW4gOwpzaG93IHRyYWNlX2xvY2tfdGFi bGUgOwpccQpfX0VPUV9fCgoK ------=NEOMAIL_ATT_0.111011637374759--