From: Scott Ribe <scott_ribe@elevated-dev.com>
To: Alessandro Dentella <sandro.dentella@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: cloudNativePg bootstrap from dump
Date: Fri, 10 May 2024 10:19:28 -0600
Message-ID: <15DE7820-429C-4163-BC59-E7608CF228B8@elevated-dev.com> (raw)
In-Reply-To: <CAFhgWoKb7nFhHteZC9x14t9i7WPvr1UBBuMvBGgtQ=d6-vjNsA@mail.gmail.com>
References: <CAFhgWoLAh18RdnqzZuFfZ-i7Zi_Z2iUUD2CwBJKRsYzWA__t+Q@mail.gmail.com>
<89AA09AC-A627-4EAB-8B0C-0EE184BD56A2@elevated-dev.com>
<CAFhgWoKb7nFhHteZC9x14t9i7WPvr1UBBuMvBGgtQ=d6-vjNsA@mail.gmail.com>
> On May 10, 2024, at 10:15 AM, Alessandro Dentella <sandro.dentella@gmail.com> wrote:
>
> 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).
>
> 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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott_ribe@elevated-dev.com, sandro.dentella@gmail.com
Subject: Re: cloudNativePg bootstrap from dump
In-Reply-To: <15DE7820-429C-4163-BC59-E7608CF228B8@elevated-dev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox