From: | Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com> |
---|---|
To: | gilberto(dot)castillo(at)etecsa(dot)cu |
Cc: | "Rossi, Maria" <maria(dot)rossi(at)us(dot)pgds(dot)com>, Postgres Maillist <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Errorlog empty |
Date: | 2015-03-12 05:02:49 |
Message-ID: | CAGDYbUNgbC80GFeHvYUEnm7UjGtVm6t7CY=mrdbRC7U9XUKH9w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Thu, Mar 12, 2015 at 3:07 AM, Gilberto Castillo <
gilberto(dot)castillo(at)etecsa(dot)cu> wrote:
>
>
> > Hi,
> > The errorlog is empty. I turned on 'log_connections', then logged-on to
> > the instance. But still the errorlog is empty. I would have expected
> > connections would appear at the log.
> > Any ideas why?
> > I am new to Postgres, so please excuse my questions.
> >
> > Maria
>
> My configuration:
>
>
> log_destination = 'stderr'
> logging_collector = on --necesita restart
> log_min_duration_statement = 0
> log_line_prefix = '%t [%p]: [%l-1] [%r]: user=%u '
> log_checkpoints = on
> log_connections = on
> log_disconnections = on
> log_lock_waits = on
> log_temp_files = 0
>
> Saludos,
> Gilberto Castillo
> La Habana, Cuba
>
> ---
> This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE
> running at host imx3.etecsa.cu
> Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
> Hi,
In postgresql.conf file you will find some ERROR REPORTING AND LOGGING
parameters.
These parameters are responsible for error log generation:
log_destination = 'stderr'
logging_collector = on
log_directory = 'pg_log'
Under When to log:
log_min_error_statement = error
log_min_duration_statement = 0
Under What to log:
log_line_prefix = '%t [%p]: [%l-1] [%r]: user=%u '
log_checkpoints = on
log_connections = on
log_disconnections = on
log_lock_waits = on
log_temp_files = 0
I think changing these parameters will start the error logs in the pg_log
folder of your data directory.
Thanks & Regards,
Ajinkya Bangale
Database Administrator
ajinkya(dot)bangale(at)shreeyansh(dot)com
Office: +919552687400/8400
www.shreeyansh.com
From | Date | Subject | |
---|---|---|---|
Next Message | Shreeyansh Dba | 2015-03-12 05:28:22 | Re: Relocated Postgres |
Previous Message | Gilberto Castillo | 2015-03-11 21:37:58 | Re: Errorlog empty |