Re: Systemd vs logging collector

From: Marc Mamin <M(dot)Mamin(at)intershop(dot)de>
To: "'Andomar'" <andomar(at)aule(dot)net>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Systemd vs logging collector
Date: 2015-07-01 09:33:43
Message-ID: B6F6FD62F2624C4C9916AC0175D56D8828BEC027@jenmbs01.ad.intershop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of Andomar
> Sent: Mittwoch, 1. Juli 2015 09:22
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] Systemd vs logging collector
>
> In Arch Linux, Postgres is started by systemd. If you configure
> logging_collector in postgresql.conf this has no effect. All of the
> logging output is send to the journal, where you can read it with
> “journalctl -u postgresql”.
>
> The configuration for systemd contains a StandardError option. I’ve
> tried various settings but none result in a regular Postgres log file.
> The Postgres settings for systemd can be found here:
> /usr/lib/systemd/system/postgresql.service
>
> Is there a way to let Postgres do its own logging when it is started by
> systemd?
>
> Kind regards,
> Andomar
>
> P.S. Trying to figure this out in order to answer this question:
> http://dba.stackexchange.com/questions/105384/postgresql-doesnt-log/

Hello,

are you just missing this parameter:

#log_destination = 'stderr' # Valid values are combinations of
# stderr, csvlog, syslog, and eventlog,
# depending on platform. csvlog
# requires logging_collector to be on.

regards,
Marc Mamin

>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org) To
> make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sameer Kumar 2015-07-01 09:45:39 Re: very slow queries and ineffective vacuum
Previous Message Marc Mamin 2015-07-01 09:21:36 Re: how to extract the page "address" from the ctid