DEV Community

Sihar Simbolon
Sihar Simbolon

Posted on • Updated 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

liborjelinek profile image

Pytest and PostgreSQL: Fresh database for every test (part I)

Libor Jelinek -

wallacefreitas profile image

Tuning Techniques for PostgreSQL Queries: How to Optimize Performance with Examples

Wallace Freitas -

vaibhav_31 profile image

NextJS Starter Kit with NextAuth v4, Prisma, Typescript and Docker

Vaibhav Arora -

krschap profile image

Raster Analysis Using Uber h3 indexes and PostgreSQL

Kshitij Raj Sharma -