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?
All of your help will be greatly appreciated.
Dan