Monday, December 13, 2010

FATAL: sorry, too many clients already

Edit postgresql.conf,then on next lines increment values

max_connections = 8
shared_buffers = 16

queries for diagnostic current sessions.

1) Select * from pg_stat_activity;
2) Select count(*) as cnt, usename, current_query FROM pg_stat_activity Group by usename,current_query Order by cnt DESC;

No comments:

OS Emulation on Ubuntu 20

    sudo apt update && sudo apt install qemu-system-x86   # Create a 1GB disk image   qemu-img create -f qcow2 win95.qcow2 1G qemu-i...