Re: Systemd vs logging collector - Mailing list pgsql-general

From Marc Mamin
Subject Re: Systemd vs logging collector
Date
Msg-id B6F6FD62F2624C4C9916AC0175D56D8828BEC027@jenmbs01.ad.intershop.net
Whole thread Raw
In response to Systemd vs logging collector  (Andomar <andomar@aule.net>)
Responses Re: Systemd vs logging collector
List pgsql-general

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Andomar
> Sent: Mittwoch, 1. Juli 2015 09:22
> To: pgsql-general@postgresql.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@postgresql.org) To
> make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Marc Mamin
Date:
Subject: Re: how to extract the page "address" from the ctid
Next
From: Sameer Kumar
Date:
Subject: Re: very slow queries and ineffective vacuum