Copying an index from one copy of a database to another

From: Martin Weinberg <weinberg(at)osprey(dot)astro(dot)umass(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Cc: weinberg(at)osprey(dot)astro(dot)umass(dot)edu
Subject: Copying an index from one copy of a database to another
Date: 2001-01-10 16:12:20
Message-ID: 200101101612.LAA27264@osprey.astro.umass.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message William Staniewicz 2001-01-10 16:23:08 converting .xls to delimited file
Previous Message Mirko Zeibig 2001-01-10 16:02:28 variable name RESULT in PLPGSQL does not work (PG7.1)