在发送到 Graylog 之前删除 Postgresql 日志中的新行

在发送到 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 中的样子 Graylog 中的 Postgresql

相关内容