How to log PostgreSQL queries?
If you would like to log all PostgreSQL queries into a file, you can do that by changing few settings int the configuration file
Open the data/postgresql.conf file and change the following settings:
#log_directory = 'pg_log’change tolog_directory = 'pg_log’#log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log’change tolog_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'#log_statement = 'none’change tolog_statement = 'all’#logging_collector = offchange tologging_collector = on- Run the following statement:
SELECT set_config('log_statement', 'all', true);
- Then restart the PostgreSQL server
sudo service postgresql restart
Now, you can find the logs in the following directory
/var/lib/pgsql/9.2/data/pg_log/
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
-
How to do error logging in CodeIgniter (PHP)
Code igniter has logging capabilities built-in. Make sure you do the following: Make your /application/logs folder writable In /application/config/config.php set the following: $config['log_thresho...
Questions -
Where can I find error log files for PHP?
PHP stores error logs in /var/log/apache2 if PHP is an apache2 module. Shared hosts are often storing log files in your root directory /log subdirectory. If you are using cPanel, the master log is ...
Questions -
How to Get the Query Executed in Laravel 5
By default, the query log is disabled in Laravel 5: Don’t worry, you can enable the query log by running the following: // enable query log DB::enableQueryLog(); Then you can display the log like t...
Questions -
How to enable MySQL Query Log?
MySQL query log stores the history of executed queries. This history is stored in a log file. On busy servers, this file ca grow very large. To enable the query log, put the following line into /et...
Questions
We are hiring.
Software is our way of making the world a tiny bit better. We build tools for the makers of tomorrow.
Help us in making the internet more reliable.
Help us with developer education and get paid.
