Re: Logging all actions

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(dot)pandey(at)pinelabs(dot)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.
> ------------------------------
>
>