In *pgadmin3*, 1) Goto, File -> Options
2) Select 'Logging' And select the option of your choice. (Debug option will log everything) Log location: ~/pgadmin.log In *pgAdmin4*, You need to change the logging configuration using "config_local.py" file, Add below config option in "config_local.py" FILE_LOG_LEVEL = logging.DEBUG Log location: ~/.pgadmin/pgadmin4.log Please note that log file is created with local user permissions so user can temper the log file. -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company On Fri, Jun 2, 2017 at 12:31 PM, Vivek Pandey <vivek.pan...@pinelabs.com> wrote: > Hello there, > > > > We are using postgres 9.3 in some of our applications in production. > Recently we were asked to implement a security measure where all actions by > an user (but not the application) gets logged in a log file. To avoid any > adverse impact on the database performance, we do not want to enable > logging at the database server level. Instead we are planning to achieve > this by logging all actions of an user in pgAdmin. > > > > Is there a feature in pgAdmin 4 or 3 through which we can achieve this? > > > > Thanks for reading. > > Vivek > > ------------------------------ > The content of this e-mail/message is intended solely for the use of the > addressee. The text of this email (including any attachments) may contain > information, which is proprietary and/or confidential or privileged in > nature belonging to Pine Labs Pvt. Ltd. If you have received this e-mail in > error, please notify the sender and remove this communication entirely from > your system. Pine Labs reserves the right to monitor and record all > emails.The recipient further acknowledges that the views contained in the > email message are those of the sender and may not necessarily reflect those > of Pine Labs Pvt. Ltd. Before opening and accessing the attachment please > check and scan for virus. Pine Labs Pvt. Ltd. accepts no liability for any > damage caused by any virus transmitted by this email. > ------------------------------ > >