Re: Dump all the indexes/constraints/roles - Mailing list pgsql-general

From Condor
Subject Re: Dump all the indexes/constraints/roles
Date
Msg-id dcb06cbe6c9561de9a571a999855f7a1@stz-bg.com
Whole thread Raw
In response to Dump all the indexes/constraints/roles  (Patrick B <patrickbakerbr@gmail.com>)
List 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 by date:

Previous
From: Raimo Jormakka
Date:
Subject: Collations and codepages
Next
From: Hanne Moa
Date:
Subject: Getting the currently used sequence for a SERIAL column