On Mon, 21 Oct 2002, Nguyen, Dan wrote: > Hello all, > > I just convert a MSQL database to PSQL and wondering if someone can help me > to duplicate or restore a database in a short period. Here is what I have > done. > > Backup <users> database: > pg_dump -C -D -n -f backupDB.psql users > > Duplicate <users> database: > 1. createdb test > 2. edit the backupDB.psql file and remove the first block regarding users > DATABASE > 3. psql -a -e -f backupDB.psql test > > > Doing this way will take about a hour to duplicate a database with about > 50,000 records. Is there any other ways that you can help me to speed up > the process?
Not using -D to pg_dump will probably help since that'll use copy rather than insert. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
