Re: Dump all the indexes/constraints/roles

From: Condor <condor(at)stz-bg(dot)com>
To: Patrick B <patrickbakerbr(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>, pgsql-general-owner(at)postgresql(dot)org
Subject: Re: Dump all the indexes/constraints/roles
Date: 2016-10-18 07:30:40
Message-ID: dcb06cbe6c9561de9a571a999855f7a1@stz-bg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hanne Moa 2016-10-18 08:45:52 Getting the currently used sequence for a SERIAL column
Previous Message Raimo Jormakka 2016-10-18 06:17:40 Collations and codepages