On Thu, Jun 02, 2016 at 02:33:34PM +0530, Dhandapani Shanmugam wrote: > I want to see the list of user who logged into XXX database in last 90 > days. How can we do this please You can't really. Unless you will modify postgresql.conf (or any other means of setting config variables), and you'll set log_connections. You might want to read https://www.postgresql.org/docs/current/static/runtime-config-logging.html or https://www.depesz.com/2011/05/06/understanding-postgresql-conf-log/ Best regards, depesz -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin