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 1s5SyH-005Wky-CX for pgsql-admin@arkaria.postgresql.org; Fri, 10 May 2024 16:19:45 +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 1s5SyF-00H36M-6t for pgsql-admin@arkaria.postgresql.org; Fri, 10 May 2024 16:19:43 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s5SyE-00H364-SR for pgsql-admin@lists.postgresql.org; Fri, 10 May 2024 16:19:43 +0000 Received: from mailout.easymail.ca ([64.68.200.34]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s5SyC-000MJy-QM for pgsql-admin@postgresql.org; Fri, 10 May 2024 16:19:42 +0000 Received: from localhost (localhost [127.0.0.1]) by mailout.easymail.ca (Postfix) with ESMTP id A2369EEFE4; Fri, 10 May 2024 16:19:39 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com; s=easymail; t=1715357979; bh=yMUWuTtTFpV304Ur/J99APWM4C5ztL8Ns9X7gh1iyaU=; h=Subject:From:In-Reply-To:Date:Cc:References:To:From; b=nEdBvt+H4moEHJ72JUpp4d8yZVrjpNxn2QwLlZ0Gz/e0VNHd6jgJcvTDleXIeFcQn +4/8CSY/hlQvbCaIa9uXD87OG8JZgRV6PouXYAxeKtmftvwzb1kHC+vA9AlKP1uQjE ZSa7jpE96djp1LyJZs4veD8S2kJMgXiNQv++gTi5+V6QQR46Gm62cG7yIUsyRetvbR qVhBsxr5ErO/kE+WMHkofcmay+zq0RBLv0Hl8V7AKCxI7IrJuZP5tHqOqd8z+gQ7Y3 TLsT918NSOBmbxNbrUdlcOIc+2QVoSnzzjVq0HtDveKRnO+L5klxm+SYsFBmND8/2B wpfVo5RIvsiYQ== X-Virus-Scanned: Debian amavisd-new at emo08-pco.easydns.vpn Received: from mailout.easymail.ca ([127.0.0.1]) by localhost (emo08-pco.easydns.vpn [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id GzWb3GXtwNDz; Fri, 10 May 2024 16:19:39 +0000 (UTC) Received: from smtpclient.apple (unknown [165.140.184.195]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mailout.easymail.ca (Postfix) with ESMTPSA id 1713FEEF92; Fri, 10 May 2024 16:19:39 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com; s=easymail; t=1715357979; bh=yMUWuTtTFpV304Ur/J99APWM4C5ztL8Ns9X7gh1iyaU=; h=Subject:From:In-Reply-To:Date:Cc:References:To:From; b=nEdBvt+H4moEHJ72JUpp4d8yZVrjpNxn2QwLlZ0Gz/e0VNHd6jgJcvTDleXIeFcQn +4/8CSY/hlQvbCaIa9uXD87OG8JZgRV6PouXYAxeKtmftvwzb1kHC+vA9AlKP1uQjE ZSa7jpE96djp1LyJZs4veD8S2kJMgXiNQv++gTi5+V6QQR46Gm62cG7yIUsyRetvbR qVhBsxr5ErO/kE+WMHkofcmay+zq0RBLv0Hl8V7AKCxI7IrJuZP5tHqOqd8z+gQ7Y3 TLsT918NSOBmbxNbrUdlcOIc+2QVoSnzzjVq0HtDveKRnO+L5klxm+SYsFBmND8/2B wpfVo5RIvsiYQ== Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.500.171.1.1\)) Subject: Re: cloudNativePg bootstrap from dump From: Scott Ribe In-Reply-To: Date: Fri, 10 May 2024 10:19:28 -0600 Cc: pgsql-admin@postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: <15DE7820-429C-4163-BC59-E7608CF228B8@elevated-dev.com> References: <89AA09AC-A627-4EAB-8B0C-0EE184BD56A2@elevated-dev.com> To: Alessandro Dentella X-Mailer: Apple Mail (2.3774.500.171.1.1) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On May 10, 2024, at 10:15=E2=80=AFAM, Alessandro Dentella = wrote: >=20 > I'd say no. based on the fact tat If I query the dimension with \l+ I = see 85 MB, that is exactly the same dim I find in a db initialized with = the same dump. where the import finishes correctly (not in k8s). >=20 > On the other side If I add -e and look at the issued SQL statement, = many create table statement are missing (but the table are there). I think -e only gives you DML, not DDL. For that you need --echo-all Maybe it's just not closing the connection as you expect when it hits = end of file? Maybe something about how that cnf command works??? Sitting there waiting for another command?