PostgreSQL/PgBouncer: Difference between revisions

From Chorke Wiki
Jump to navigation Jump to search
No edit summary
Line 26: Line 26:
sudo cat /etc/pgbouncer/pgbouncer.ini|less
sudo cat /etc/pgbouncer/pgbouncer.ini|less
</syntaxhighlight>
</syntaxhighlight>
|}
==Playground==
{|
|valign='top'|
<syntaxhighlight lang="bash">
ls -lah /var/log/postgresql/
ls -lah /var/run/postgresql/
</syntaxhighlight>
|valign='top'|
|valign='top'|
|-
|colspan='3'|
----
|-
|valign='top'|
|valign='top'|
|valign='top'|
|}
|}



Revision as of 00:40, 19 September 2024

cat <<-'EXE'|sudo bash
apt-get update;echo
apt list -a --upgradable
sudo apt-get install -y pgbouncer
EXE
     systemctl status  pgbouncer.service

sudo systemctl stop    pgbouncer.service
sudo systemctl start   pgbouncer.service
sudo systemctl restart pgbouncer.service
 ls -lah /etc/pgbouncer/

sudo cat /etc/pgbouncer/userlist.txt
sudo cat /etc/pgbouncer/pgbouncer.ini
sudo cat /etc/pgbouncer/pgbouncer.ini|less

Playground

ls -lah /var/log/postgresql/
ls -lah /var/run/postgresql/

References