Reload server configuration

You can use several ways to do it: in pgAdmin – right click on connection and choosing “Reload configuration” in psql / pgAdmin – using SQL: select pg_reload_conf(); from Linux – as postgres (if your PGDATA variable is set): pg_ctl reload...

Log all queries into server log

To log all queries which are processed on PostgreSQL 8.4 or 9.3 server you have to enable / add / change these lines in your postgresql.conf file: log_statement = all log_min_error_statement = error log_min_duration_statement = 0   useful is also: log_line_prefix...