By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,660 Members | 1,267 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,660 IT Pros & Developers. It's quick & easy.

getting configure options?

P: n/a
CSN
Is is possible to find out what options (prefix,
bindir, etc.) were specified to "configure" when
Postgres was built?

__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Tue, Dec 23, 2003 at 01:46:02PM -0800, CSN wrote:
Is is possible to find out what options (prefix,
bindir, etc.) were specified to "configure" when
Postgres was built?


http://www.postgresql.org/docs/curre...-pgconfig.html

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 12 '05 #2

P: n/a

On 23/12/2003 21:46 CSN wrote:
Is is possible to find out what options (prefix,
bindir, etc.) were specified to "configure" when
Postgres was built?


pg_config --configure

HTH

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+

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

Nov 12 '05 #3

P: n/a
Yes. Although you can use the pg_config table as suggested, I prefer using
the functions provided with Postgres for this purpose. To find out
configuration settings, use the current_setting() function. It takes a
single varchar parameter: the name of the setting you are inquiring about.
E.g.,:

=> select current_setting('search_path');

The complementary function as an (unfortunately) unrelated name:
set_config( config_param_name, config_param_value, is_local). The is_local
boolean flag indicates whether the setting should apply only to the current
transaction or whether it should be held onto for the entire session
(connection). The "local" version only makes sense if you are inside of a
transaction block.

Example usage:

=> select set_config('search_path', 'information_schema', false);

Note that most settings can be configured on a per-database and per-user
basis. This is recommended if you want a setting to be there everytime a
user connects or the db is started. Also, some settings (like whether to
fsync() or not) are global and can only be set in the configuration files or
on the command line at server start up.

HTH

== Ezra Epstein

"CSN" <co*******************@yahoo.com> wrote in message
news:20************************@web40601.mail.yaho o.com...
Is is possible to find out what options (prefix,
bindir, etc.) were specified to "configure" when
Postgres was built?

__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.