Re: [HACKERS] src/test/subscription/t/002_types.pl hanging onparticular environment

 

Parallel query has a very clearly scoped lifetime, which seems to help. The parallel workers are started by a leader, whose lifetime entirely encompasses that of the workers. They're strictly children of the leader process.

In logical replication, the logical replication manager doesn't start the walsenders, they're started by the postmaster in response to inbound connections.

But the logical replication launcher does start the managers, and the managers start the apply workers. (IIRC). If we don't mind the whole thing dying and restarting if the launcher dies,  or workers for a db dying if a database manager dies, then using dsm segments and detach notifications does seem viable.

IIRC when we did something similar in pglogical we ran into problems with (a) inability to handle an ERROR in a bgworker without exiting and being restarted by the postmaster; and (b) the postmaster remembering bgworker registrations across crash restart with no way to tell it not to. Maybe Petr remembers the details?