I need to know if the database was accessed from a specific IP. In which log file (if any) is information about the history of calls to the Postgresql 9.5 database stored? The base is installed on Windows 7 Professional. Is it possible to observe this somehow through PgAdmin III?
|
1 answer
Setting must be enabled
log_connections = on Then the database connection will be recorded in the DBMS log. Then, in any convenient way, look for connection information from the required host in the log.
By default, this setting is disabled.
Where the log itself is a separate question. When logging_collector enabled (the same setting), the DBMS log will be written to the directory specified in the log_directory setting
Small small
14.4k one ten 35
|