| From: | John Lumby <johnlumby(at)hotmail(dot)com> |
|---|---|
| To: | pgsql general <pgsql-general(at)postgresql(dot)org> |
| Subject: | RegisterBackgroundWorker does not actually start a bg worker process in 9.4.4 |
| Date: | 2015-06-15 18:58:51 |
| Message-ID: | COL131-W797566963E38D7BFE52BFFA3B80@phx.gbl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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?
Cheers, John
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2015-06-15 19:19:34 | Re: localtime ? |
| Previous Message | Yaroslav | 2015-06-15 18:55:58 | Re: Row count estimation bug in BETWEEN? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2015-06-15 19:12:24 | Re: Function to get size of notification queue? |
| Previous Message | Amit Kapila | 2015-06-15 18:52:54 | Re: Re: [COMMITTERS] pgsql: Map basebackup tablespaces using a tablespace_map file |