Skip site navigation (1) Skip section navigation (2)

Re: suggestion

From: "Jan Cruz" <malebug(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: suggestion
Date: 2006-02-23 23:58:38
Message-ID: 493da2780602231558h6edf395eqf5dd6719e6a71dda@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On 2/24/06, Michael Glaesemann <grzm(at)myrealbox(dot)com> wrote:
>
>
> Have you looked at the --schema-only flag?
>
> http://www.postgresql.org/docs/current/interactive/app-pgdump.html
>
> If this doesn't do what you want, can you give a bit more
> explanation? Also, what are you trying to do with this dump file?
>
> Michael Glaesemann
> grzm myrealbox com



--schema-only flag is the equivalence of -s

I also want an option that would exclude  "CREATE INDEX "  whenever
a schema is being dump

The reason for this is that whenever I tried to migrate database
whenever I restore a schema with indexes and then
restore the data separately it took more or less 24 hours instead of
the usual 1 hour more or less.

For example let say I want to use this particular schema from the test
server
since the stored functions and/or views are already updated

and then my data would come from the production server which has a different

version of postgres and the schema (particularly the stored functions/views)
that
would is already deprecated from the test server.

So I just need to dump the schema from the test server without the indexes
and restore the new schema to a new database/server and restore the dump
from the production server to the new database/server.

I hope I explain my side properly

In response to

Responses

pgsql-hackers by date

Next:From: Jim C. NasbyDate: 2006-02-24 00:02:41
Subject: Re: suggestion
Previous:From: Kevin GrittnerDate: 2006-02-23 23:54:24
Subject: fsutil ideas

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group