Which queries have run query trace form .exe.

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Which queries have run query trace form .exe.

Vimal Kanzariya
Hello,

I need find out some database operation which is executed form One of the .exe. I have installed that .exe into my system and once i executed that .exe it is executed some operation into PostgreSQL 9.5 (version 1.22.1). So i want to know what operation done by that .exe into which table. is there any tool or any other way to find out database operation executed form .exe.?

--
Thanks
Vimal Kanzariya
Reply | Threaded
Open this post in threaded view
|

Re: Which queries have run query trace form .exe.

Ron-2
On 1/7/19 6:52 AM, Vimal Kanzariya wrote:
Hello,

I need find out some database operation which is executed form One of the .exe. I have installed that .exe into my system and once i executed that .exe it is executed some operation into PostgreSQL 9.5 (version 1.22.1). So i want to know what operation done by that .exe into which table. is there any tool or any other way to find out database operation executed form .exe.?

Look at the log_* options in postgresql.conf. https://www.postgresql.org/docs/9.5/runtime-config-logging.html

Here's an example:
log_destination = 'stderr'
logging_collector = on
log_directory = '/Database/9.6/pg_log'
log_filename = 'postgresql-%F_%H.log'
log_truncate_on_rotation = off
log_rotation_age = 1h
log_rotation_size = 0
client_min_messages =  log
log_min_messages = info
log_min_error_statement = info
log_line_prefix = '%m %r %u %d %p %i %a %e '


--
Angular momentum makes the world go 'round.