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