On Tue, Jun 16, 2015 at 3:58 AM, John Lumby <johnlumby@hotmail.com> wrote:
> I am new to bg_workers so this may be my user error,
> but when I build and run the contrib/worker_spi
> extension, I find that :
>
> . starting postgres with the extension named in shared_preload_libraries :
> its _PG_init is invoked as expected but no process is started -
> it is as though RegisterBackgroundWorker did nothing
>
> . creating the extension and then
> psql ... "select worker_spi_launch(2);" :
> I see
> 28409 28288 ? 463508 00:05 00:00:00 0.0 postgres: bgworker: worker 2
> as expected.
>
> Is there maybe some bug in postmaster's processing of
> workers marked as start_at = BgWorkerStart_RecoveryFinished
> in 9.4.4?
Not that I know of. I am using static background workers even with 9.4
clusters and they work as expected. Giving a try with worker_spi on
9.4, I see no problems as well:
$ ps ux | grep bgworker
michael 3906 0.0 0.1 2594780 7456 ?? Ss 8:21AM 0:00.02
postgres: bgworker: worker 1
michael 3905 0.0 0.1 2594780 6996 ?? Ss 8:21AM 0:00.02
postgres: bgworker: worker 2
$ psql -c 'show shared_preload_libraries'
shared_preload_libraries
--------------------------
worker_spi
(1 row)
Regards,
--
Michael