Re: pg_restore schema dump to schema with different name

Поиск
Список
Период
Сортировка
От Nagaraj Raj
Тема Re: pg_restore schema dump to schema with different name
Дата
Msg-id 543515895.715906.1629741273076@mail.yahoo.com
обсуждение исходный текст
Ответ на Re: pg_restore schema dump to schema with different name  (Jean-Christophe Boggio <postgresql@thefreecat.org>)
Ответы Re: pg_restore schema dump to schema with different name  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-performance
Дерево обсуждения

Wouldn’t be easy if we have option to_schema ? 

Absolutely, I should not alter current schema, as it live 24/7.

Thanks,
Rj
On Monday, August 23, 2021, 06:39:03 AM PDT, Jean-Christophe Boggio <postgresql@thefreecat.org> wrote:



> The only way to do that is to create a new database, import the data
> there, rename the schema and dump again.
>
> Then import that dump into the target database.


Or maybe (if you can afford to have source_schema unavailable for some
time) :

* rename source_schema to tmp_source
* import (that will re-create  source_schema)
* rename source_schema to destination_schema
* rename back tmp_source to source_schema



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

Предыдущее
От: Jean-Christophe Boggio
Дата:
Сообщение: Re: pg_restore schema dump to schema with different name
Следующее
От: Matt Dupree
Дата:
Сообщение: Re: Postgres using the wrong index index