Re:

From: Loles <lolesft(at)gmail(dot)com>
To: Dilip Kumar <dilipbalaut(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re:
Date: 2021-05-17 05:56:48
Message-ID: CA+FWGK5x0WYmNvGrD5skd92banh-dhLDDQUwVqhspwEfDuM3xg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I don't understand why the server starts that process if I'm not using
replication of any kind.

The server starts it with the default configuration of version 13.

I think that it consumes resources that I do not need because, as I have
commented, I will not use replication of any kind.

El lun, 17 may 2021 a las 7:41, Dilip Kumar (<dilipbalaut(at)gmail(dot)com>)
escribió:

> On Mon, May 17, 2021 at 12:18 AM Loles <lolesft(at)gmail(dot)com> wrote:
> >
> > Hi!
> >
> > Let's see if someone can answer my question.
> >
> > In a default PostgreSQL 13 installation, starting the server starts a
> process called "logical replication launcher".
> >
> > I know what logical replication is but I don't know what this process
> does on the server.
> >
> > Even if you change the default setting of wal_level to minimal, the
> process continues to start after the server is restarted so that it takes
> the change in the wal_level parameter.
>
> This process launches the worker process for each subscription for
> applying the logical replication changes. It does not matter what is
> the wal level, because wal level should be logical to create a
> publisher but this is used for launching the worker for the
> subscriber. So in short this process will scan the subscriber and
> launches the apply worker if there is no worker corresponding to some
> subscription.
>
> --
> Regards,
> Dilip Kumar
> EnterpriseDB: http://www.enterprisedb.com
>

In response to

  • Re: at 2021-05-17 05:41:02 from Dilip Kumar

Responses

  • Re: at 2021-05-17 06:37:29 from David G. Johnston

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2021-05-17 06:37:29 Re:
Previous Message Dilip Kumar 2021-05-17 05:41:02 Re: