Re: cloudNativePg bootstrap from dump

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Alessandro Dentella <sandro(dot)dentella(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: cloudNativePg bootstrap from dump
Date: 2024-05-10 16:19:28
Message-ID: 15DE7820-429C-4163-BC59-E7608CF228B8@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On May 10, 2024, at 10:15 AM, Alessandro Dentella <sandro(dot)dentella(at)gmail(dot)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?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Wells Oliver 2024-05-10 16:20:28 Re: Observation with Postgres table size
Previous Message Alessandro Dentella 2024-05-10 16:15:50 Re: cloudNativePg bootstrap from dump