Cannot specify database with space in name in config

[Bilge]

Although the documentation seems to claim that simply quoting the dbname is sufficient, the following config will cause PgBouncer to cease to start up:

[databases]
"Foo Bar" = host=foo

ERROR syntax error in configuration (/etc/pgbouncer/pgbouncer.ini:14), stopping loading

Nevertheless, in general, PgBouncer handles such database names just fine. We know this because the following config works:

[databases]
* = host=foo

Whereafter we can connect to a database so named "Foo Bar" or whatever else. It seems this is simply a bug in the configuration parser.

[JelteF]

Yes, this is a problem. This should be fixed in a libusual its cfparser: https://github.com/libusual/libusual/blob/master/usual/cfparser.c

Feel free to provide a PR on that repo.

[Bilge]

I think that may be beyond my ability. Maybe it's time to switch to a real file format?