Date: Thu, 2 Jun 2016 08:47:04 +0000 (UTC)
From: Glyn Astill <glynastill@yahoo.co.uk>
Reply-To: Glyn Astill <glynastill@yahoo.co.uk>
To: Dhandapani Shanmugam <postgresql95@gmail.com>,
	"pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Message-ID: <2019574206.5819817.1464857224506.JavaMail.yahoo@mail.yahoo.com>
In-Reply-To: 
 <CAAj4MFES75wcVzO+K52PetsfFROUQ0bNMdJHn4HW0G-sb8D+uA@mail.gmail.com>
References: 
 <CAAj4MFES75wcVzO+K52PetsfFROUQ0bNMdJHn4HW0G-sb8D+uA@mail.gmail.com>
Subject: Re: user logging info
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Length: 1065
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

> From: Dhandapani Shanmugam <postgresql95@gmail.com>
>To: pgsql-admin@postgresql.org 
>Sent: Thursday, 2 June 2016, 7:21
>Subject: [ADMIN] user logging info
> 
>
>
>Hi All,
>
>
>Good Day!
>
>
>Please clarify me on below points :)
>
>
>-Can we see user connections on any system tables(active + past) in postgreSQL, Please share me the SQL if it is possible.

>

Can you clarify what you want to see here?  You can see the current and last queries of connections with "SELECT * FROM pg_stat_activity".  If you want auditing or logging of all activity then depending on what you need it's possible with triggers or an extension like pg_audit.

>
>-.I assume postgresql.conf can be modified so that user connections are logged in a log file. 

>

Yes turn on log_connections and log_disconnections, see the "what to log" section here:

    https://www.postgresql.org/docs/current/static/runtime-config-logging.html

>>Is this best approach or how can we do to check for the user connection details? any advise is really helpful. Thanks in Advance
>
>
>-Dhandapani
>
>


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin