Bug 410647

Summary:	dev-db/pgbouncer - add new option "upgrade" in init.d script
Product:	Gentoo Linux	Reporter:	Marcin Mirosław <bug>
Component:	Current packages	Assignee:	Johan Bergström <bugs>
Status:	RESOLVED FIXED
Severity:	enhancement	CC:	pgsql-bugs, titanofold
Priority:	Normal
Version:	unspecified
Hardware:	All
OS:	Linux
Whiteboard:
Package list:		Runtime testing required:	---
Bug Depends on:
Bug Blocks:	419171
Attachments:	pgbouncer.initd

Description Marcin Mirosław 2012-04-03 11:35:23 UTC

Pgbouncer is able to do online upgrade (like e.g. nginx). Here is info about it: http://pgbouncer.projects.postgresql.org/doc/faq.html#_how_to_upgrade_pgbouncer_without_dropping_connections

It's enough to start new process with added new swith "-R" to do upgrade.

Comment 1 Johan Bergström 2012-04-03 20:37:17 UTC

I've experienced issues with this (crashing, not working properly and whatnot), so that's why I chose to leave it outside for now. I can't say those were within the last two releases, and my personal reason't aren't really valid for more than me.I'll update the init script to add this, thanks.

Comment 2 Marcin Mirosław 2012-04-03 21:39:31 UTC

Hmm, once time pgbouncer -R (version 1.5) didn't detach from terminal. I couldn't reproduce it, i assumed it was accident. But it seems "upgrade" isn't perfect stable.

Comment 3 Johan Bergström 2013-01-03 02:35:08 UTC

Created attachment 334118 [details]
pgbouncer.initd

This new init script adds support for upgrade. It also fixes bug 410645.

Comment 4 Sergey Popov gentoo-dev

2013-01-14 17:26:56 UTC

+  14 Jan 2013; Sergey Popov <pinkbyte@gentoo.org> files/pgbouncer.initd:
+  Update initscript, fix bugs #410645 and #410647, thanks to Johan Bergström