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

Поиск
Список
Период
Сортировка
От Melvin Davidson
Тема Re: Postgresql upgrade to 9.5.12/10.3 changes pg_dump format forcloning schemas
Дата
Msg-id CANu8Fix7LiJdiLrBmdGZyfuuD+HV=tRj3-D+8Gb-AVK0Cs3GWw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgresql upgrade to 9.5.12/10.3 changes pg_dump format forcloning schemas  (Melvin Davidson <melvin6925@gmail.com>)
Список pgsql-general
Дерево обсуждения

On Tue, Mar 13, 2018 at 1:47 PM, Melvin Davidson <melvin6925@gmail.com> wrote:



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!

Aldrin,

I've solved the problem with the sequences.

The attached clone_schema_10.sql has been tested on my system and now works.
Let me know if you find any bugs. As you also said it is not robust enough, Please also let me know what additional features you think it needs.


--
Melvin Davidson
Maj. Database & Exploration Specialist
Universe Exploration Command – UXC
Employment by invitation only!
Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: query_to_xml() returns invalid XML when query returns no rows
Следующее
От: Joe Conway
Дата:
Сообщение: Re: Reindex doesn't eliminate bloat