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 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 -
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 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 -
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
Make your mark
Join the writer's program
Are you a developer and love writing and sharing your knowledge with the world? Join our guest writing program and get paid for writing amazing technical guides. We'll get them to the right readers that will appreciate them.
Write for us
Build on top of Better Stack
Write a script, app or project on top of Better Stack and share it with the world. Make a public repository and share it with us at our email.
community@betterstack.comor submit a pull request and help us build better products for everyone.
See the full list of amazing projects on github