Re: cloudNativePg bootstrap from dump - Mailing list pgsql-admin

From Scott Ribe
Subject Re: cloudNativePg bootstrap from dump
Date
Msg-id 15DE7820-429C-4163-BC59-E7608CF228B8@elevated-dev.com
Whole thread Raw
In response to Re: cloudNativePg bootstrap from dump  (Alessandro Dentella <sandro.dentella@gmail.com>)
Responses While creating a user in PostgreSQL 15 getting ERROR: require a VALID UNTIL option
List pgsql-admin
> 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
ina 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
tableare 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
commandworks??? 

Sitting there waiting for another command?




pgsql-admin by date:

Previous
From: Alessandro Dentella
Date:
Subject: Re: cloudNativePg bootstrap from dump
Next
From: Wells Oliver
Date:
Subject: Re: Observation with Postgres table size