DEV Community

Sihar Simbolon
Sihar Simbolon

Posted on • Edited on

How to restart PostgreSQL with PgBouncer assist

This is step that I use for restarting postgresql.
Note:
Please do this on development only

pgbouncer> KILL dbname; 
Enter fullscreen mode Exit fullscreen mode

Restart postgresql

$ sudo systemctl restart postgresql-12
Enter fullscreen mode Exit fullscreen mode

Resume dbname from pgbouncer

pgbouncer> RESUME dbname;
Enter fullscreen mode Exit fullscreen mode

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay