The all-time trusted tool for backup and restore is postgres' own pg_dump and pg_restore
To see the command options: pg_dump --help pg_restore --help It can be tricky to use because you have to put into a good combination of flags. Some flags you may wish to use with pg_dump is -b and -Fc Anyway, you have already have the problem solved. You can try out these commands and options again for routine backup uses. Regards, Allen Lam. HKU Hub Administrator, http://hub.hku.hk Stan Orlov wrote: > Another crisis averted :) I tried to export the database via Navicat's > MS Access format and it imported vi Navicat on the new box just fine > (although I'll have to re-assign primary keys, apparently). Before, I > was trying to export in a text delimited format, but it would mess up > field lengths and primary/foreign keys. So, it seems to be working. > Thanks for your advice! > > Cheers, > Stan > ------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
