pgbouncer – small hints

simplest config file /etc/pgbouncer/pgbouncer: [databases] * = host=127.0.0.1 port=5432 ;;user binding like this - add all users it is safer postgres = host=localhost dbname=postgres [pgbouncer] logfile = /var/log/postgresql/pgbouncer.log pidfile =...

Out of shared memory error

This error you get when you create in one moment too many locks on tables in all transactions together. Situation when I encountered it was – many parallel queries from parent table with cca 100 child tables. Error looks like this: [txt] WARNING:  out of...

Server process was terminated by signal 9: Killed

If you see in PostgreSQL log something like this: LOG: server process (PID xxxxx) was terminated by signal 9: Killed following by termination of other PostgeSQL processes and database going into recovery mode and you wonder what happend than most probable cause is...

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