On Tue, Jun 16, 2015 at 3:58 AM, John Lumby <johnlu...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
