[#1011301] Easier management of database list

View Trackers | Feature Requests | Download .csv | Monitor

Date:
2013-02-07 08:57
Priority:
3
State:
Open
Submitted by:
Michał Pokrywka (szaman)
Assigned to:
Nobody (None)
Category:
None
Group:
None
Summary:
Easier management of database list

Detailed description
It would be easier to manage databases configuration if the list could be stored in some separate place.

One way to solve this would be pgbouncer.ini including config files from /etc/pgbouncer/conf.d/ directory or similar.

The other way would be an option to store database list in some dedicated database.

Followup

Message
Date: 2013-02-11 13:39
Sender: Michał Pokrywka

Experimenting by myself, I've produced a patch for 1.5.2 version (from debian wheezy), but it works with current git version (1.5.4) as well.

Patch consists of:
1. adding databases_file option to pgbouncer.ini,
2. adding function cf_load_file_sect in lib/usual/cfparser.[hc] to load entries from .ini file without defining section - function gets section name as an argument,
3. while loading config, check if option databases_file is set; if so, load this file using cf_load_file_sect function using the same main_config variable as for primary config file.

I'm providing this patch, because it could be useful while implementing the feature I requested or because someone may benefit from it on his own. However, I'm not any pg* stuff developer and I realise the proper implementation could be different, suggestions appreciated!

Attached Files:

Attachments:
pgbouncer-externaldbfile.patch

Changes:

Field Old Value Date By
File Added792: pgbouncer-externaldbfile.patch2013-02-11 13:39szaman
Powered By FusionForge