Re: Restoring using PG_DUMP in PG12 results in

2022-03-15 Thread Adrian Klaver
On 3/14/22 23:42, Shukla, Pranjal wrote: Thanks Adrian, Can we say that, "Despite an informational Error, entire data got imported with sanity in the original case"? Yes. To verify see that the public schema is there and has tables and other objects in it. Also, can we say that either of th

Re: Restoring using PG_DUMP in PG12 results in

2022-03-15 Thread Shukla, Pranjal
Thanks Adrian, Can we say that, "Despite an informational Error, entire data got imported with sanity in the original case"? Also, can we say that either of the approaches mentioned i.e. Approach 1 & 2 are equally good to do migration from PG 10 to PG 12? Thanks & Regards Pranjal Shukla On 3/

Re: Restoring using PG_DUMP in PG12 results in

2022-03-14 Thread Adrian Klaver
On 3/14/22 06:39, Shukla, Pranjal wrote: Hello, We tried importing into an empty database in PG 12 from the dump that was created in PG 10. Import was successful but we got an message that an error was ignored. We agin imported with -e option and the following message was printed: pg_restor

Restoring using PG_DUMP in PG12 results in

2022-03-14 Thread Shukla, Pranjal
Hello, We tried importing into an empty database in PG 12 from the dump that was created in PG 10. Import was successful but we got an message that an error was ignored. We agin imported with -e option and the following message was printed: pg_restore: while PROCESSING TOC: pg_restore: from TO