Re: Postgresql upgrade to 9.5.12/10.3 changes pg_dump format for cloning schemas

[Melvin Davidson <melvin6925@xxxxxxxxx>]

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!