Re: Errorlog empty

On Thu, Mar 12, 2015 at 11:09 PM, Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
wrote:

> On Mar 12, 2015, at 11:12 AM, Rossi, Maria <maria(dot)rossi(at)us(dot)pgds(dot)com>
> wrote:
> >
> > Igor,
> >
> > Here's the other 'log' configs: Thanks.
> >
> > postgres=# show log_destination;
> > log_destination
> > -----------------
> > stderr
> > (1 row)
> >
> > postgres=# show log_filename;
> > log_filename
> > ---------------
> > gp07error.log
> > (1 row)
> >
> > postgres=# show log_directory;
> > log_directory
> > -----------------------------
> > /dba/pgsql/gp07/pg_errorlog
> > (1 row)
> >
> > postgres=# show log_connections;
> > log_connections
> > -----------------
> > on
> > (1 row)
> >
> > postgres=# show log_disconnections;
> > log_disconnections
> > --------------------
> > on
> > (1 row)
> >
>
> What about logging_collector? If that's not set, I think your log filename
> will be ignored and messages will go to stderr. See: <
> http://www.postgresql.org/docs/9.4/static/runtime-config-logging.html>
>
> --
> Scott Ribe
> scott_ribe(at)elevated-dev(dot)com
> http://www.elevated-dev.com/
> (303) 722-0567 voice
>
>
>
>
>
>
> --
> 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,

Reload is fine no need to restart.
you can check whether parameters are configured using

SHOW <parameter-name>;

May be there some permission issue to the log_destination folder.So once
check the permissions and
Try

log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
log_file_mode = 0600

And let me know the output.

--
Thanks & Regards
Ajinkya Bangale
Database Administrator
Ph: +91-9552688400 / 7400
Email ID: *ajinkya(dot)bangale(at)shreeyansh(dot)com <ajinkya(dot)bangale(at)shreeyansh(dot)com>*
www.shreeyansh.com