Warning: is_dir(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/data/web/virtuals/98151/virtual) in /data/web/virtuals/98151/virtual/www/subdom/postgresql/wp-content/plugins/wp-simple-firewall/src/lib/vendor/fernleafsystems/wordpress-services/src/Core/Fs.php on line 465

Warning: Cannot modify header information - headers already sent by (output started at /data/web/virtuals/98151/virtual/www/subdom/postgresql/wp-content/plugins/wp-simple-firewall/src/lib/vendor/fernleafsystems/wordpress-services/src/Core/Fs.php:465) in /data/web/virtuals/98151/virtual/www/subdom/postgresql/wp-content/plugins/disable-xml-rpc-pingback/disable-xml-rpc-pingback.php on line 51
server configuration Archives - PostgreSQL Candies

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...