Re: Export / import of a db

DMina_at_laiki.com wrote:
> The database size is approximately 58GB (used space) and the exported
> dump file is 28GB

I don't like any of the answers that quickly come to mind ... so here's what I'd do.

1. Create the exact same tablespaces that previously existed
2. Import into a schema created temporarily just for the import
3. Move the data to the desired storage locations in the final schema
4. Dump the temporary schema
5. Dump the extra tablespaces

A pain but it solves the problem and protects you against many possible accidents.

But if someone has a better idea, and I hope they do, I'd like to hear it.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)