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

indrayyana profile image

Building a RESTful API with Go Fiber: An Express-Inspired Boilerplate

Indra Adnyana -

jolouie7 profile image

React Express NeonDB starter kit

Joseph Louie -

zaratedev profile image

How to create a read-only user in PostgreSQL

Jonathan Zarate -

liborjelinek profile image

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

Libor Jelinek -