Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tMWt8-004nWp-BT for pgsql-admin@arkaria.postgresql.org; Sat, 14 Dec 2024 18:29:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tMWt5-005gJC-Ft for pgsql-admin@arkaria.postgresql.org; Sat, 14 Dec 2024 18:29:12 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tMWt5-005gJ3-2W for pgsql-admin@lists.postgresql.org; Sat, 14 Dec 2024 18:29:12 +0000 Received: from mail-oo1-xc36.google.com ([2607:f8b0:4864:20::c36]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tMWt3-002qc4-St for pgsql-admin@postgresql.org; Sat, 14 Dec 2024 18:29:11 +0000 Received: by mail-oo1-xc36.google.com with SMTP id 006d021491bc7-5f31b3db5ecso1160021eaf.0 for ; Sat, 14 Dec 2024 10:29:09 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1734200946; x=1734805746; darn=postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=l4fgR48qloGwafdPAtsVJQgOZSH7svcG3PV59qpYkeE=; b=UDbtaHN3dVuWcGoO419eqoqUjKNSiZtI9pJ6nqWZ1v/W/A/gRr+brdAeCqNhEYAe1h vSwBnNCSFEse6k4iidCDA2hXsJcJyTW9a7SEXVSe/Yo7wADI2oDjh7NLsmlj11iF+3Pm DC7DwziQ1+1zEfO0iBDRp5PyhZyjCrLo17z/xyMKR/Hr3AVZ90fTea4fufbOSj3SDj5Q +SX7qT3DaNQ9TNmgGn/Q8IpMJcVk5fKIqJ6DXNZXzCPlffUmt8MIzAxHXcRaRvl1fzgL uakTRy2HiTBX75v/yiwV7xxVLzOlJf8DXdhmh6HKi2bc1F+3DPIGKYrWNk6zwasXkul6 3/yQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1734200946; x=1734805746; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=l4fgR48qloGwafdPAtsVJQgOZSH7svcG3PV59qpYkeE=; b=rMvyvDavb5Ix4qfYDGB/eNkP0awDmX+7MSFobNNcbWGTMgPcfnC4oEidAf1O88Qy9c 51TlOxRkXZIDDov6u6jxPmBXUWFOlHoQtFvIiAHkAQLg1yeP6UZoE4n2+Q7JXTrcaJC9 55j/cA7x9RFpxBFDkL6aNT8wyKxzpCHzlF6TH0waghqku2zPQgeijmsstYCoSGtHeqAk 74fh6MpiHRe2ka3m96SJzsQqyTEg4eTYkEfuDj8S7Q1AOTwPFItrs/XLjXIKNmgmsYax Jz2w2FzeDGsM+DDARN6pjJEVtOUJ/aJUlQ4IDuwkV/Kz92Lo923EW3qqXqNcNuzdb6VT /etw== X-Gm-Message-State: AOJu0Yyqpl+vGNW1oT+ufHkYPjg3446ZId8O6Zy1YuOD9aVoly855+nV 51sXAO+YvJ8afSSC1gy9PEqzFZTJiHlLbMM0KzaWyPmsbgbXqaKGoWQ353ulEivJUdl6+vhSvWk PHY36TlM8BO6+s0TV8/l55gCNc7GBcdGe X-Gm-Gg: ASbGncs0nAzy23kMhjzHh1gQV0A4g2++5nspHJ2dU9AqMnnP1Ble+zWpZLZaykj+yRQ l+E/WvDLgnbjrtQeccs2zssB/bjTFfaodlT6QgM4= X-Google-Smtp-Source: AGHT+IGsC0XYNbFXQ3Vm8o86bfXEu7I+EA+N9jR+0z/yWEsOiS9kWaDNcQQcSLG84KF4m/tSw0fSjgfIbldI3uBqeHo= X-Received: by 2002:a05:6870:3d97:b0:297:26a1:3d03 with SMTP id 586e51a60fabf-2a3ac4914b7mr3141960fac.4.1734200946191; Sat, 14 Dec 2024 10:29:06 -0800 (PST) MIME-Version: 1.0 From: Ron Johnson Date: Sat, 14 Dec 2024 13:28:55 -0500 Message-ID: Subject: Why might it take so long to start up a cleanly-stopped instance? To: pgsql-admin Content-Type: multipart/alternative; boundary="0000000000005df85906293f1f08" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000005df85906293f1f08 Content-Type: text/plain; charset="UTF-8" PG 14.15 on RHEL 7.9 This is a rather small system, and only one or two user connections existed at the time. $ pg_ctl stop -wt9999 && pg_ctl start -wt9999 waiting for server to shut down........... done server stopped waiting for server to start.................................................................................................................................................................................................................................2024-12-14 13:21:10.820 EST 24567 00000 LOG: 00000: redirecting log output to logging collector process 2024-12-14 13:21:10.820 EST 24567 00000 HINT: Future log output will appear in directory "/var/log/postgresql". 2024-12-14 13:21:10.820 EST 24567 00000 LOCATION: SysLogger_Start, syslogger.c:674 . done server started -- Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --0000000000005df85906293f1f08 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
PG 14.15 on RHEL 7.9

This is= a rather small system, and only one or two user connections existed at the= time.

$ pg_ctl stop -wt9= 999 && pg_ctl start -wt9999
waiting for server to shut down.....= ...... done
server stopped
waiting for server to start...............= ...........................................................................= ...........................................................................= ............................................................2024-12-14 13:21:10.820 EST=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 24567=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 000= 00 =C2=A0 LOG: =C2=A000000: redirecting log output to logging collector pro= cess
2024-12-14 13:21:10.820 EST= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 24567=C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 00000 =C2=A0 HINT: =C2=A0Future log output will appear in dir= ectory "/var/log/postgresql".
2024-12-14 13:21:10.820 EST=C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 24567=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 00000 =C2=A0 LOCATION: =C2=A0SysLogger_Start, syslogger.c:674. done
server started

--
Death to <Redacte= d>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
--0000000000005df85906293f1f08--