PAUSE and RESUME support

[lesovsky]

Hi,

Pgbouncer has special commands such as PAUSE and RESUME

PAUSE [db];
PgBouncer tries to disconnect from all servers, first waiting for all queries to complete. The command will not return before all queries are finished. To be used at the time of database restart.

If database name is given, only that database will be paused.

RESUME [db];
Resume work from previous PAUSE or SUSPEND command.

Is it possible to implement the similar commands. It allows to make postgres restart permanently for clients without their disconnection.

[lukashes]

Any updates with this issue?

[pmwkaa]

Hey, there are some work in progress regarding it: #66. Looks like this feature is quite expected :)

[x4m]

The feature was merged.

[davidfetter]

This feature was un-merged, so the issue should be re-opened.

[glushakov]

Hi. Any updates?

[x4m]

@glushakov I've recently deployed Odyssey 1.1 to public Yandex.Cloud. Currently, fixing any possible problems is number 1 priority. And most of my time is occupied with monitoring how things work. But everything seems to be quite smooth, few minor fixes are coming.
After a week or so I'll switch back again to new features, and merging PAUSE and standby lag polling is number 1 on my TODO list. Also there are few nasty bugs in SCRAM implementation, which do not affect YC, but need to be fixed, probably earlier than PAUSE, but I'm not sure.

[lex-sey]

When will this functionality be ready?