Backup method and vacuumdb
| От | guillermo schulman |
|---|---|
| Тема | Backup method and vacuumdb |
| Дата | |
| Msg-id | F36EEmYDKFJ2I13pL320001d2d4@hotmail.com обсуждение |
| Список | pgsql-novice |
I'm doing some migration script from mysql database to an existing postgresql database. Everytime I want to test it, I want to get the postgres "destination" database to the same situation it was before the last script was run. I am doing a backup with pgdump and restoring by droping the database and running the script generated by pgdump. The backup looks like this: pg_dump -h <hostname> -U <username> -c dbname > /tmp/database.pgdump The restore looks like this: psql -h <hostname> -U <username> template1 -c "drop database dbname;" psql -h <hostname> -U <username> template1 < /tmp/database.pgdump But this aproach is taking a long time and the database is becoming slower every time. So: which is the best backup/restore method to apply in this case? And about the performance, I'm using vacuumdb but I don't know when to do it. Any idea? Thanks _________________________________________________________________ Charla con tus amigos en línea mediante MSN Messenger: http://messenger.yupimsn.com/
В списке pgsql-novice по дате отправления: