pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Getting the value of a config parameter in runtime
3+ messages / 3 participants
[nested] [flat]
* Getting the value of a config parameter in runtime
@ 2008-12-31 11:35 Jaume Sabater <jsabater@gmail.com>
2008-12-31 00:07 ` Re: Getting the value of a config parameter in runtime AmitKumar Jain <amitjain@synechron.com>
2008-12-31 13:05 ` Re: Getting the value of a config parameter in runtime Guillaume Lelarge <guillaume@lelarge.info>
0 siblings, 2 replies; 3+ messages in thread
From: Jaume Sabater @ 2008-12-31 11:35 UTC (permalink / raw)
To: pgsql-admin
Hi all!
Sorry to ask this, I had it noted down but now I cannot find it and
I've been googling for 30 minutes now without success. There is a way
to query the system database to get the current value of a
configuration parameter, something in the form of SELECT value FROM
some_table WHERE field_name = 'archive_command', or similar, can't
remember, honestly. Or perhaps something more generic which was
filtered with greps, tails, heads and cuts.
Would someone be so kind as to point me at the right page or remind me
the way it was done?
Thanks in advance.
--
Jaume Sabater
http://linuxsilo.net/
"Ubi sapientas ibi libertas"
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Getting the value of a config parameter in runtime
2008-12-31 11:35 Getting the value of a config parameter in runtime Jaume Sabater <jsabater@gmail.com>
@ 2008-12-31 00:07 ` AmitKumar Jain <amitjain@synechron.com>
1 sibling, 0 replies; 3+ messages in thread
From: AmitKumar Jain @ 2008-12-31 00:07 UTC (permalink / raw)
To: Jaume Sabater <jsabater@gmail.com>; +Cc: pgsql-admin
You can configuration parameter value from psql prompt by typing
show all ;
or
show [paramter name]
e.g show shared_buffers;
Jaume Sabater wrote:
> Hi all!
>
> Sorry to ask this, I had it noted down but now I cannot find it and
> I've been googling for 30 minutes now without success. There is a way
> to query the system database to get the current value of a
> configuration parameter, something in the form of SELECT value FROM
> some_table WHERE field_name = 'archive_command', or similar, can't
> remember, honestly. Or perhaps something more generic which was
> filtered with greps, tails, heads and cuts.
>
> Would someone be so kind as to point me at the right page or remind me
> the way it was done?
>
> Thanks in advance.
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Getting the value of a config parameter in runtime
2008-12-31 11:35 Getting the value of a config parameter in runtime Jaume Sabater <jsabater@gmail.com>
@ 2008-12-31 13:05 ` Guillaume Lelarge <guillaume@lelarge.info>
1 sibling, 0 replies; 3+ messages in thread
From: Guillaume Lelarge @ 2008-12-31 13:05 UTC (permalink / raw)
To: Jaume Sabater <jsabater@gmail.com>; +Cc: pgsql-admin
Jaume Sabater a écrit :
> [...]
> Sorry to ask this, I had it noted down but now I cannot find it and
> I've been googling for 30 minutes now without success. There is a way
> to query the system database to get the current value of a
> configuration parameter, something in the form of SELECT value FROM
> some_table WHERE field_name = 'archive_command', or similar, can't
> remember, honestly. Or perhaps something more generic which was
> filtered with greps, tails, heads and cuts.
>
> Would someone be so kind as to point me at the right page or remind me
> the way it was done?
>
Table is pg_settings, and your field_name should be name.
Regards.
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-12-31 13:05 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-12-31 11:35 Getting the value of a config parameter in runtime Jaume Sabater <jsabater@gmail.com>
2008-12-31 00:07 ` AmitKumar Jain <amitjain@synechron.com>
2008-12-31 13:05 ` Guillaume Lelarge <guillaume@lelarge.info>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox