Received: from malur.postgresql.org ([2a02:16a8:dc51::56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1fri0y-0007lb-Jo
	for pgsql-admin@arkaria.postgresql.org; Mon, 20 Aug 2018 11:06:28 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1fri0u-0003ez-E9
	for pgsql-admin@arkaria.postgresql.org; Mon, 20 Aug 2018 11:06:24 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pavan.postgresdba@gmail.com>)
	id 1fri0u-0003es-6v
	for pgsql-admin@lists.postgresql.org; Mon, 20 Aug 2018 11:06:24 +0000
Received: from n3.nabble.com ([162.255.23.22])
	by magus.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pavan.postgresdba@gmail.com>)
	id 1fri0r-00007t-Cw
	for pgsql-admin@postgresql.org; Mon, 20 Aug 2018 11:06:23 +0000
Received: from n3.nabble.com (localhost [127.0.0.1])
	by n3.nabble.com (Postfix) with ESMTP id 468BAEA77EBB
	for <pgsql-admin@postgresql.org>; Mon, 20 Aug 2018 04:06:20 -0700 (MST)
Date: Mon, 20 Aug 2018 04:06:20 -0700 (MST)
From: pavan95 <pavan.postgresdba@gmail.com>
To: pgsql-admin@postgresql.org
Message-ID: <1534763180286-0.post@n3.nabble.com>
In-Reply-To: <1534761820283-0.post@n3.nabble.com>
References: <1534758116021-0.post@n3.nabble.com>
 <1534761820283-0.post@n3.nabble.com>
Subject: Re: How to enable Logon Trigger in postgres?
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk

Hi Pascal,

Thanks for your reply. But I think with pgaudit we can log only to the
Postgres log file. 

1) Can we log the same pgaudit information into a table automatically?

2) I want to implement a task such that I do have two servers one is
monitoring server and the other production server. So how will pgaudit will
help me in getting all production server audit data to table in monitoring
server automatically. Can we do it??

Looking forward to hear from you! Thanks in Advance.

Regards,
Pavan



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html