Search Postgresql Archives

Re: Systemd vs logging collector

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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

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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux