Re: Postgresql upgrade to 9.5.12/10.3 changes pg_dump format forcloning schemas - Mailing list pgsql-general

From Melvin Davidson
Subject Re: Postgresql upgrade to 9.5.12/10.3 changes pg_dump format forcloning schemas
Date
Msg-id CANu8FiwDR41FYzJwSceZF6doacK7XVDZ0q148vRzvDZaZwoT4Q@mail.gmail.com
Whole thread Raw
In response to Re: Postgresql upgrade to 9.5.12/10.3 changes pg_dump format forcloning schemas  (Aldrin Martoq Ahumada <aldrin.martoq@gmail.com>)
Responses Re: Postgresql upgrade to 9.5.12/10.3 changes pg_dump format forcloning schemas  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general



Thank you Melvin, I forgot to mention I've already found your script before I asked here, but I didn’t think it was robust enough (please don't offend :-). Particularly, it didn't work well on PostgreSQL 10.


Aldrin,

I apologize. I just tested and found that the reason it is failing is because, once again, the catalogs have been changed. In this case the structure of sequences.
I am trying to find a workaround. I will get back to you when I do.


--
Melvin Davidson
Maj. Database & Exploration Specialist

Universe Exploration Command – UXC

Employment by invitation only!

pgsql-general by date:

Previous
From: Aldrin Martoq Ahumada
Date:
Subject: Re: Postgresql upgrade to 9.5.12/10.3 changes pg_dump format forcloning schemas
Next
From: Thomas Kellerer
Date:
Subject: Re: query_to_xml() returns invalid XML when query returns no rows