Copying an index from one copy of a database to another - Mailing list pgsql-general

From Martin Weinberg
Subject Copying an index from one copy of a database to another
Date
Msg-id 200101101612.LAA27264@osprey.astro.umass.edu
Whole thread Raw
Responses Re: Copying an index from one copy of a database to another  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Folks,

We have a database with 1.2 billion records (about 300GB not
including indices).

The data is static but indices are build and dropped as needed.
Because the indexing is time consuming, we would like to maintain
two separate copies of the database: one for indexing and one for
production.

The question is:

Is there a way to copy the index from one copy of the database
to another copy without copying all of the data?

Right now, we are copying the entire data directory, which is
a bit painful.

--Martin

===========================================================================

Martin Weinberg                      Phone: (413) 545-3821
Dept. of Physics and Astronomy       FAX:   (413) 545-2117/0648
530 Graduate Research Tower
University of Massachusetts
Amherst, MA  01003-4525



pgsql-general by date:

Previous
From: Karel Zak
Date:
Subject: Re: [HACKERS] How to print explain using PHP
Next
From: "Brian E. Pangburn"
Date:
Subject: Re: converting .xls to delimited file