Postgres Pro
Downloads
Home   >   mailing lists

Thread: [pgadmin-support] Logging all actions

[pgadmin-support] Logging all actions

From
"Vivek Pandey"
Date:

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.

Re: [pgadmin-support] Logging all actions

From
Murtuza Zabuawala
Date:
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.pandey@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.