Re: Dump all the indexes/constraints/roles

Поиск
Список
Период
Сортировка
От Condor
Тема Re: Dump all the indexes/constraints/roles
Дата
Msg-id dcb06cbe6c9561de9a571a999855f7a1@stz-bg.com
обсуждение исходный текст
Ответ на Dump all the indexes/constraints/roles  (Patrick B <patrickbakerbr@gmail.com>)
Список pgsql-general
On 18-10-2016 06:32, Patrick B wrote:
> Hi guys,
>
> I need to export an entire database to another server, for testing
> purpose.
>
> Is there any way to export all indexes and constraints ?
> Postgres 9.2
> Patrick


Hello,

pg_dump database is that you need, but if you asking do you can export
data + indexes like binary data of indexes to can
you restore data fast without to wait all indexes to be create / rebuild
on another server answer is: NO, you can't export them.


Regards,
Hristo S


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

Предыдущее
От: Raimo Jormakka
Дата:
Сообщение: Collations and codepages
Следующее
От: Hanne Moa
Дата:
Сообщение: Getting the currently used sequence for a SERIAL column