On Fri, Feb 24, 2006 at 07:58:38AM +0800, Jan Cruz wrote: > On 2/24/06, Michael Glaesemann <[EMAIL PROTECTED]> wrote: > --schema-only flag is the equivalence of -s > > I also want an option that would exclude "CREATE INDEX " whenever > a schema is being dump
At least on my small test database, all the CREATE INDEX commands are one-liners. This means it would be trivial to exclude them with grep -v 'CREATE INDEX, or grab just them with grep 'CREATE INDEX'. I'd just stick the greps in between cat and psql -f -. > 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 -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings