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 ) id 1frgi4-00032H-QU for pgsql-admin@arkaria.postgresql.org; Mon, 20 Aug 2018 09:42:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1frgi2-0005pL-E2 for pgsql-admin@arkaria.postgresql.org; Mon, 20 Aug 2018 09:42:50 +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 ) id 1frghG-0002DV-Je for pgsql-admin@lists.postgresql.org; Mon, 20 Aug 2018 09:42:02 +0000 Received: from n3.nabble.com ([162.255.23.22]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1frghC-0006R0-Ij for pgsql-admin@postgresql.org; Mon, 20 Aug 2018 09:42:00 +0000 Received: from n3.nabble.com (localhost [127.0.0.1]) by n3.nabble.com (Postfix) with ESMTP id 7F814EA72BC0 for ; Mon, 20 Aug 2018 02:41:56 -0700 (MST) Date: Mon, 20 Aug 2018 02:41:56 -0700 (MST) From: pavan95 To: pgsql-admin@postgresql.org Message-ID: <1534758116021-0.post@n3.nabble.com> Subject: How to enable Logon Trigger in postgres? MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi all, I wanted to know whether we can store logon(user login/logout) information for a database. In specific I want to know at what time which user had logged in and what he performed on the database and the time which he logged off? Is it possible to get this level of information in Postgres? Will be very happy if we can get this piece of information from the postgres(inbuilt/any tool). Looking forward to hearing from you! Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html