Обсуждение: BUG #11404: Current PostgreSQL Databases Configuration

Поиск
Список
Период
Сортировка

BUG #11404: Current PostgreSQL Databases Configuration

От
srinivas.mca41@gmail.com
Дата:
The following bug has been logged on the website:

Bug reference:      11404
Logged by:          Sreenivasulu
Email address:      srinivas.mca41@gmail.com
PostgreSQL version: 9.2.1
Operating system:   Linux
Description:


Hi All,

1.How to check Current configuration of the database (settings/maintenance
etc).
2.Steps to do while a reboot of the server.

Please share asap.

Thanks in Advance....

Re: BUG #11404: Current PostgreSQL Databases Configuration

От
Jaime Casanova
Дата:
On Thu, Sep 11, 2014 at 10:19 PM,  <srinivas.mca41@gmail.com> wrote:
> The following bug has been logged on the website:
>
> Bug reference:      11404
> Logged by:          Sreenivasulu
> Email address:      srinivas.mca41@gmail.com
> PostgreSQL version: 9.2.1
> Operating system:   Linux
> Description:
>
>
> Hi All,
>

This is clearly *not* a bug, please use pgsql-admin@postgresql.org for
this kind of questions


> 1.How to check Current configuration of the database (settings/maintenanc=
e
> etc).

for settings look at pg_settings
for manintenance: what are you looking for? autovacuum_* parameters?
you can find them in pg_settings too

> 2.Steps to do while a reboot of the server.
>

ah? if postgresql is running as a service then nothing, otherwise stop
postgresql first


--=20
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitaci=F3n
Phone: +593 4 5107566         Cell: +593 987171157