Graylog로 보내기 전에 Postgresql 로그에서 새 줄을 제거하십시오.

Postgresql 로그를 Graylog로 보내기 전에 모든 새 행을 제거하고 싶습니다. 예,

2018-08-30 00:00:00 WIB [29212] hi_user@myDatabase 172.21.253.44 LOG:  duration: 1044.000 ms  execute 32:
                            SELECT
                                    talk_id,
                                    product_id,
                                    shop_id,
                                    user_id,
                                    message,
                                    total_comment,
                                    create_time,
                                    status,
                                    fraud_status
                            FROM
                                    ws_talk
                            WHERE
                                    ws_talk.status = 1 AND ws_talk.product_id IN(298932598,309360018,300809172,309360017,300809175,300809174,300809173,298932597,25748655) AND create_time > '2018-01-01 00:00:00'
                                            AND ws_talk.shop_id = 216771
                            ORDER BY talk_id DESC
                            LIMIT 11 OFFSET 0

이렇게되어야합니다

2018-08-30 00:00:00 WIB [29212] hi_user@myDatabase 172.21.253.44 LOG:  duration: 1044.000 ms  execute 32:
SELECT talk_id, product_id, shop_id, user_id, message, total_comment, create_time, status, fraud_status FROM ws_talk WHERE ws_talk.status = 1 AND ws_talk.product_id IN(298932598,309360018,300809172,309360017,300809175,300809174,300809173,298932597,25748655) AND create_time > '2018-01-01 00:00:00' AND ws_talk.shop_id = 216771 ORDER BY talk_id DESC LIMIT 11 OFFSET 0

나는 이것이 더 낫다고 생각했다.

이것이 Graylog의 모습입니다.