Re: [pgadmin-support] Logging all actions

Поиск
Список
Период
Сортировка
От Murtuza Zabuawala
Тема Re: [pgadmin-support] Logging all actions
Дата
Msg-id CAKKotZQbRvq198JUc1kq4UOBxBE7Qp0JOwL8v7QtUPjVSyFSxg@mail.gmail.com
обсуждение исходный текст
Ответ на [pgadmin-support] Logging all actions  ("Vivek Pandey" <vivek.pandey@pinelabs.com>)
Список pgadmin-support
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.


В списке pgadmin-support по дате отправления:

Предыдущее
От: "Vivek Pandey"
Дата:
Сообщение: [pgadmin-support] Logging all actions
Следующее
От: "petrov.boris.v@mail.ru"
Дата:
Сообщение: [pgadmin-support] pgadmin4: "The application server could not be contacted."