Best pg_dump practices
От | MT |
---|---|
Тема | Best pg_dump practices |
Дата | |
Msg-id | 20030612125812.515e6402.m_tessier@sympatico.ca обсуждение исходный текст |
Список | pgsql-general |
Hi, Now that I've painstakinly entered my data into the db, I'd like to perform regular backups using pg_dump as such pg_dump -c -f dumpfile.sql dbname This will give me the data in its original, pristine form. Note that using pg_dump this way means that the data gets dumpedas copy too. Is there a way to dump only the db objects (ie. tables, sequences, etc) and exclude the data. Then, as the db is used, I would perform daily backups, automated with cron. pg_dump -a -f daily_dumpfile.sql dbname I would then tar and gzip the daily_dumpfile.sql and upload it to a backup server. Now, if the database should suddenly crash, I would do retrieve the dumpfiles, untar them and psql dbname \i dumpfile.sql This would create the db in its original form. \i daily_dumpfile.sql This would bring the reconstituted db up to date. Then again, »I'm not sure if this works. Furthermore, maybe someone could recommend a better way to perform this task. -- Thanks, Mark
В списке pgsql-general по дате отправления: