Re: Errorlog empty

Поиск
Список
Период
Сортировка
От Shreeyansh Dba
Тема Re: Errorlog empty
Дата
Msg-id CAGDYbUNec-iES8d4owy5US-SPL3Z7cUr8d5mufrwaCTdygHLsQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Errorlog empty  (Scott Ribe <scott_ribe@elevated-dev.com>)
Ответы Re: Errorlog empty  ("Rossi, Maria" <maria.rossi@us.pgds.com>)
Список pgsql-admin


On Thu, Mar 12, 2015 at 11:09 PM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
On Mar 12, 2015, at 11:12 AM, Rossi, Maria <maria.rossi@us.pgds.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@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice






--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.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.bangale@shreeyansh.com
www.shreeyansh.com

В списке pgsql-admin по дате отправления:

Предыдущее
От: Jiří Hlinka
Дата:
Сообщение: Re: pg_repack 1.3.1 RPM whan available?
Следующее
От: Khangelani Gama
Дата:
Сообщение: I am working on trying to improve a database perfomance in version 9.2 Postgresql database server