From: Koichi Suzuki <koichi(at)2ndquadrant(dot)com>
> I'm not using this. Is this the must to use get_database_name()?
I don't think pg_background is a must, but the system catalog access by get_database_name() should require database connection and transaction. See src/test/modules/worker_spi/worker_spi.c for an example of background worker. That uses both of them.
Regards
Takayuki Tsunakawa