DEV Community

Sihar Simbolon
Sihar Simbolon

Posted on • Edited on

How to restart PostgreSQL with PgBouncer assist

#postgres #pgbouncer

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)

Read next

aungthuoo profile image

Install PostgreSQL in a Docker Container

Aung Thu Oo -

kaustubhyerkade profile image

Maximizing Performance: Best Practices for Database Scaling

kaustubh yerkade -

dm8ry profile image

Automate Foreign Key Index Checks in PostgreSQL: A Practical Bash Script

Dmitry Romanoff -

acetrondi profile image

Using Supabase SMS-Hook to Send Custom Authentication Messages in India

acetrondi -