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 1sJEjs-003a3l-P6 for pgsql-general@arkaria.postgresql.org; Mon, 17 Jun 2024 15:57:48 +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 1sJEjq-0019TK-GY for pgsql-general@arkaria.postgresql.org; Mon, 17 Jun 2024 15:57:47 +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 1sJEjq-0019TC-3Y for pgsql-general@lists.postgresql.org; Mon, 17 Jun 2024 15:57:47 +0000 Received: from mail-ot1-x32a.google.com ([2607:f8b0:4864:20::32a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sJEjo-0028pi-PG for pgsql-general@postgresql.org; Mon, 17 Jun 2024 15:57:46 +0000 Received: by mail-ot1-x32a.google.com with SMTP id 46e09a7af769-6f9611fc320so2025256a34.2 for ; Mon, 17 Jun 2024 08:57:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1718639862; x=1719244662; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=N2rooJB91HOjpcPK16EL/nIY+79uI7XnMghpj3OCqV8=; b=BWvfi4xE8xhjXZGkMarvxokba24mTTSm5rozKepzdn1bWNp08+4y4ydJstcSjTufhg AuRXxg11Zv809h2Rcth9u9A1M2YuK+2kG/L1TMRcJNnSouDBk39e+yGaHrw+NwYca59z hKWdKl54poWdU7cmadW+GYQli0WFiqJJFi3+ZzgUlJHc2EHCh5Ne4EThpzsBoltMjodH XB9rMvZJZQ/S/rmHTVw4U93QoP88HO4HInKJqX6G3whqXz1/DJLZvKg/X2fGStW+Imzr JzRJT7R1Fey9MwgZrEsa2QSctuoqnY4vhoQaRfuXSbpGRmZxWJ8gDKc/3AfWu86dfmWO SLpQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1718639862; x=1719244662; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=N2rooJB91HOjpcPK16EL/nIY+79uI7XnMghpj3OCqV8=; b=eOpRTSHKBhhwS6mqyxhUiUMVoZ57SP639Jt/MLAUXSCviJUwvSjlAtpHEW5PQDq309 EnOffmBH/z139QE5UsrE35fnGxziCeRlFN34UvVDSryznGpEsZF/CPt5YvQHwsaXBomj BCxjTxt04imDIP/gMs70Rnr6YdkGDg6AGzI8cp1DyKD1bC4uqLghnyNRtAxmfFOQK2kH ZdzjKp0RyQIZQqgAp7rn0exCYB5khhkRQNnYQJlZZSA0vnHPsJZKnMr8H1Ifz1ft3Teu BTRs1VJzbQxyLlUPXeJvhKfZ1JCobNUcQ+vH3xA8Z4Gwdx50MjCJWZ2xMjSEQ67y/oYx pdXg== X-Gm-Message-State: AOJu0Yy1VrsaU984Qg+N+itZb1u1s2jItlg/IRUbIzMr1rmcIdgOyPgL 1qpfTvcfkXUioGdTv+VVhX+ymO6QN/U/ywLr9JbDBfcM9t/uEp/sa3AsAkbSFERDr4tUNjTcUcJ 2SW1vIdUlh2wCXIx82xDG6RbLMjpnVA== X-Google-Smtp-Source: AGHT+IFMC4BMalmVBs/tZJXVqbWF1OAcW0YHUOpYFNGQNqlQb/FyEzFz+sfxAvs9l0vgtgWjMhzKviry0fkkhBxL+H0= X-Received: by 2002:a05:6870:3906:b0:254:b2e8:163d with SMTP id 586e51a60fabf-258428b4e11mr11931297fac.19.1718639862440; Mon, 17 Jun 2024 08:57:42 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Mon, 17 Jun 2024 11:57:30 -0400 Message-ID: Subject: Re: WAL settings for larger imports To: pgsql-general Content-Type: multipart/alternative; boundary="0000000000007f69e0061b180676" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000007f69e0061b180676 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, Jun 17, 2024 at 9:46=E2=80=AFAM Benoit, Eric wrot= e: > What is a good data import configuration for only one server for > WRITE-AHEAD LOG settings postgresql.conf where no one is connecting to th= e > database accept me as a superuser. > How worried are you about data loss / database corruption? Is streaming or logical replication enabled? --0000000000007f69e0061b180676 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Mon, Jun 17, 2024 at 9:46=E2=80=AFAM B= enoit, Eric <ebenoit@e1b.org> = wrote:
What is a good data import configuration for only one server for WRITE-AHEA= D LOG settings postgresql.conf where no one is connecting to the database a= ccept me as a superuser.

= How worried are you about data loss / database corruption?

Is streaming or logical replication enabled?

<= blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l= eft:1px solid rgb(204,204,204);padding-left:1ex">
--0000000000007f69e0061b180676--