Обсуждение: archive_command / single user mode

Поиск
Список
Период
Сортировка

archive_command / single user mode

От
Christophe Pettus
Дата:
Does archive_command run in single user mode?  This isn't an actual situation at the moment, but for runbook / disaster
planningpurposes, I was curious. 


Re: archive_command / single user mode

От
"David G. Johnston"
Дата:
On Mon, Aug 9, 2021 at 4:17 PM Christophe Pettus <xof@thebuild.com> wrote:
Does archive_command run in single user mode?  This isn't an actual situation at the moment, but for runbook / disaster planning purposes, I was curious.


Nope.

If I follow the source code correctly...main.c calls PostgresMain (postgres.c) which is basically a hybrid front-end/back-end standalone setup which, as far as I can tell, never launches the archiver.  The "else" PostmasterMain (postmaster.c) call in main.c, however, leads to ServerLoop which starts, and restarts if necessary, the archiver based upon the current state machine state (e.g., PM_RUN).

Skimming the imports for postgres.c likewise confirms an omission of pgarch.h ...

David J.

Re: archive_command / single user mode

От
Christophe Pettus
Дата:

> On Aug 9, 2021, at 18:03, David G. Johnston <david.g.johnston@gmail.com> wrote:
>
> On Mon, Aug 9, 2021 at 4:17 PM Christophe Pettus <xof@thebuild.com> wrote:
>> Does archive_command run in single user mode?  This isn't an actual situation at the moment, but for runbook /
disasterplanning purposes, I was curious. 
>
>
> Nope.

That seems entirely logical.  Thank you!