BUG #11404: Current PostgreSQL Databases Configuration

Lists: PostgreSQL : PostgreSQL 메일 링리스트 : 2014-09-12 이후 PGSQL 윈 토토 03:19
From: srinivas(dot)mca41(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #11404: Current PostgreSQL Databases Configuration
Date: 2014-09-12 03:19:03
Message-ID: 20140912031903.2489.11949@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: PostgreSQL : PostgreSQL 메일 링리스트 : 2014-09-12 이후 PGSQL 윈 토토 03:19

The following bug has been logged on the website:

Bug reference: 11404
Logged by: Sreenivasulu
Email address: srinivas(dot)mca41(at)gmail(dot)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....


From: Jaime Casanova <jaime(at)2ndquadrant(dot)com>
To: srinivas(dot)mca41(at)gmail(dot)com
Cc: pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #11404: Current PostgreSQL Databases Configuration
Date: 2014-09-12 04:30:21
Message-ID: CAJKUy5jOE3zzLReRqGHB=JpG=EyYXeyULCwvQ7ckJ=KGLJ9Ztg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

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

This is clearly *not* a bug, please use pgsql-admin(at)postgresql(dot)org for
this kind of questions

> 1.How to check Current configuration of the database (settings/maintenance
> 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

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