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 1tuu73-00DiGA-3q for pgsql-general@arkaria.postgresql.org; Wed, 19 Mar 2025 14:09:41 +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 1tuu71-005U9i-Gk for pgsql-general@arkaria.postgresql.org; Wed, 19 Mar 2025 14:09:39 +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 1tuu71-005U8B-5E for pgsql-general@lists.postgresql.org; Wed, 19 Mar 2025 14:09:39 +0000 Received: from mail-il1-x132.google.com ([2607:f8b0:4864:20::132]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tuu6x-003lwf-1B for pgsql-general@lists.postgresql.org; Wed, 19 Mar 2025 14:09:38 +0000 Received: by mail-il1-x132.google.com with SMTP id e9e14a558f8ab-3d442a77a03so20025735ab.1 for ; Wed, 19 Mar 2025 07:09:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1742393375; x=1742998175; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=gQBZFJ7esPy1BgyiNoMpZFSJVU5tjMDPiQ68TNsUWcw=; b=mzeO94Sbv6v4wBn2Xg+84uy4Ic/RibggAFZLqAtPeHJTT2FpCaW2pS2da632/HgSmL +IAAcTq3qMmCPbhM2AjiBhsW/LF+q75mC2o6kvyHwrkCAam1Q+SKx7iyC5E9beuxZuG3 bhWK+XhkHQT43zg6pB3b5YmyqM6KraUUandzRa1JnKIqveOnC6tKGjJlhALrqVxhF1At 9XLM5LFpEJaxE3cjQYv25s4vH12bWkin02ztrOwv8PN5BgFJwxpuBuaoZw7nUNIo+Jpk YauHOoz2MM5juFnqdr7cpuL4vF/Y5BlHDvh24PATEs+bJVa2e++3l399MSyDbUR1NG4N VzIA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1742393375; x=1742998175; h=cc: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=gQBZFJ7esPy1BgyiNoMpZFSJVU5tjMDPiQ68TNsUWcw=; b=Yb87W9YDw2nE7BxS26JNOq/+88ZRPNPo6y+XUmJ6c4Cqwz+kdBsYyjE0WFtmmGj7Mg rctjvPDvKXvWckoXVfyG4TDeKiWcZ5ewZnB7JMEjRZGHeNPi51aHokRohULO/idOpdQi kSUEhQmc2PcfxMi58/2J+dpJpIIG9F0G427O0rhDzC29kh8bTGYrsAJynf5M6LfPuLKF 9fBhIWPUbcnk/3mh8VoDB8mt7gJFFJ2njkNiG/XLiQXTiQpEAM+ZbjQ064y6xKkIAnI6 lS7HO7ezlfMvdSHfFnb23OEks21JcjkqkGPdB7+TInSv362mti6y1aTIY3JAVU5nuK8l FzKw== X-Gm-Message-State: AOJu0Yw3PS++L4TkWujmS2nTuoAwBEoBRsLsjkRJVW1mufPaVVa/hun/ pnaZaBYUlNiZ3VTKNYEypdQszA52DbNUP5DgsFmWF1j9N1sjU6Qm9QM7ZybpPZKLTgW3eg6N541 kFSz8KjUnG8/NLS5NQlYalDO9OWdGDwvg X-Gm-Gg: ASbGnctrixONQ0ryHVJ/KvQVRfZoSSe08LLWjjiIHxqm+5LmKUnMAtuLAUpzUyyiseI 721MsuRY80gta0I+/yiFSWuCtbZVwLKl9ciuiNh6I+6/tb0a3XyeKtAYEG9YikIZJPa/ekUPlcb GeUBpO1AitRF9CVeyhJDXoZV69S0JZzC+WXAEgqTALpwMYJjGSsGf6HmYlx6Sc X-Google-Smtp-Source: AGHT+IE2NLnT/EdaA0HQ61tUVAn2WYdxuhIi+WGA3Biz34TmJNpgvjcPxeN3MgMs0ThaZ6+e2hZywtSBY9aqVMoXo9M= X-Received: by 2002:a05:6e02:1a0e:b0:3d4:6f37:3724 with SMTP id e9e14a558f8ab-3d586ba4dbamr29816285ab.18.1742393374743; Wed, 19 Mar 2025 07:09:34 -0700 (PDT) MIME-Version: 1.0 References: <92435272-360f-48fa-8ca0-a4ea89359c80@e-blokos.com> In-Reply-To: From: Greg Sabino Mullane Date: Wed, 19 Mar 2025 10:08:58 -0400 X-Gm-Features: AQ5f1JpnRLb5xjrjFcXQtCm44ZwhrKolMdKX1BbW2niAuclvgtM1pbWjsXEtx8M Message-ID: Subject: Re: Cannot pg_dump_all anymore... To: E-BLOKOS Cc: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000002926880630b292d8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000002926880630b292d8 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wed, Mar 19, 2025 at 10:02=E2=80=AFAM E-BLOKOS wrot= e: > is it possible a crash happened with a VACUUM and a machine reboot in sam= e > time? > More likely to be a problem with pg_repack. Please tell us the exact versions of pg_repack and Postgres in use here. Cheers, Greg -- Crunchy Data - https://www.crunchydata.com Enterprise Postgres Software Products & Tech Support --0000000000002926880630b292d8 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, Mar 19, 2025 at 10:02=E2=80=AFAM = E-BLOKOS <admin@e-blokos.com&g= t; wrote:
=20 =20 =20

is it possible a crash happened with a VACUUM and a machine reboot in same time?


More l= ikely to be a problem with=C2=A0pg_repack.=C2=A0 Please tell us the exact v= ersions of pg_repack and Postgres in use here.

--0000000000002926880630b292d8--