> -----Ursprüngliche Nachricht----- > Von: Christophe Pettus <xof@xxxxxxxxxxxx> > Gesendet: Dienstag, 24. Januar 2023 16:48 > An: Zwettler Markus (OIZ) <Markus.Zwettler@xxxxxxxxxx> > Cc: pgsql-general@xxxxxxxxxxxxxxxxxxxx > Betreff: [Extern] Re: Is a logical replication crash recovery safe? > > > > > On Jan 24, 2023, at 07:37, Zwettler Markus (OIZ) <Markus.Zwettler@xxxxxxxxxx> > wrote: > > > > Is a logical replication crash recovery safe? > > You might want to give more detail about the scenario you are concerned about. > Changes that are received by a subscriber as part of logical replication are WAL- > logged, observe transaction semantics, and will be replayed if the subscriber > crashes and restarts. > Sorry. Let me refine. If I create a logical replication slot and use the replication slot to publish some tables. Will the information in the replication slot be safe for any subscription even if a crash recovery happened on the publisher node?