Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WUcKx-0004B8-7z for pgsql-admin@arkaria.postgresql.org; Mon, 31 Mar 2014 13:33:15 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WUcKw-00052D-Di for pgsql-admin@arkaria.postgresql.org; Mon, 31 Mar 2014 13:33:14 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WUcKv-000526-8B for pgsql-admin@postgresql.org; Mon, 31 Mar 2014 13:33:13 +0000 Received: from mail-la0-x22a.google.com ([2a00:1450:4010:c03::22a]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WUcKs-0008Ff-Op for pgsql-admin@postgresql.org; Mon, 31 Mar 2014 13:33:12 +0000 Received: by mail-la0-f42.google.com with SMTP id ec20so5887965lab.29 for ; Mon, 31 Mar 2014 06:33:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=from:content-type:content-transfer-encoding:subject:message-id:date :to:mime-version; bh=5em08F5P/KsREcXkWfc4NAPo3A8mv7PjvgxBxRg2j/w=; b=Afh9sf2PiJ3g+8Nx77aPDFnXE7DRe7zQR22E2qzXnW7itAtObkY3434qj/ztcLhXOu i8Ml3lycGnvX4BUWzykcaENwh3JxJoB3nrHvbZvKrrfPE+RReMp/0IwN4CFweYUteuz3 lpWuw3PwbluQ+u1Gz4AtDpE03UB19JrJisHHhRbuTc7vZt0spy8iS9hQS0DQQterkvw3 webfEoXlo/I5lReYjBXPUARO4SSvA4ZCOD5JhG+BcqeOybNeNel5nnbi8+PYAiM2OLBg zZZuZTXQNH34duOwH3KMR/TJnAgsgv7eCV3w+QG+SE3tXu7NSkEyrK2Zo4KiF0oOwGdy nb9w== X-Received: by 10.112.158.105 with SMTP id wt9mr1970339lbb.31.1396272788983; Mon, 31 Mar 2014 06:33:08 -0700 (PDT) Received: from [192.168.1.200] ([188.134.10.29]) by mx.google.com with ESMTPSA id cr6sm9951993lbb.19.2014.03.31.06.33.07 for (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Mon, 31 Mar 2014 06:33:08 -0700 (PDT) From: Sergey Arlashin Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Subject: PostgreSQL 9.3 logging: separate log messages Message-Id: Date: Mon, 31 Mar 2014 17:33:06 +0400 To: "pgsql-admin@postgresql.org" Mime-Version: 1.0 (Mac OS X Mail 6.6 \(1510\)) X-Mailer: Apple Mail (2.1510) X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Hi! What is the proper way to separate queries from other messages while loggin= g? For example: I have 'log_min_duration_statement' parameter in postgresql.conf . Therefor= e I get postgresql system messages and slow queries in one log file /var/lo= g/postgresql/postgresql-9.3-main.log .=20 In order to simplify further reading I'd like to get slow queries in /var/l= og/postgresql/postgresql-slowqueries.log and all the rest in /var/log/postg= resql/postgresql.log.=20 I tried to implement this by means of rsyslog but didn't manage to get any = decent result.=20 Any help will be greatly appreciated :) -- Best regards, Sergey Arlashin --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin