| From: | Ian Lawrence Barwick <barwick(at)gmail(dot)com> |
|---|---|
| To: | Vincent Veyron <vv(dot)lists(at)wanadoo(dot)fr> |
| Cc: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com>, Postgresql General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: fastest dump/restore |
| Date: | 2014-01-27 11:35:58 |
| Message-ID: | CAB8KJ=imvuhCVr0k9n7r2VseBuEEhasg44tu3W0qzsdZp0tgrw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2014-01-27 Vincent Veyron <vv(dot)lists(at)wanadoo(dot)fr>:
> Le dimanche 26 janvier 2014 à 10:27 -0700, Scott Ribe a écrit :
>> Is there an article anywhere which documents everything the current state of the art for the fastest dump/restore? What dump/restore format & options? What things to tweak in the config? I've picked up a few bits here and there along the line, but was just wondering if there's a comprehensive source of current advice.
>
>
> pg_dump has its documentation :
> http://www.postgresql.org/docs/9.3/static/app-pgdump.html
>
> see also 14.4.9. Some Notes About pg_dump in :
> http://www.postgresql.org/docs/9.3/static/populate.html
The wiki page for the 9.3 release has some notes and links to blog articles
describing the new parallel dump feature for pg_dump:
https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.3#Parallel_pg_dump_for_faster_backups
Regards
Ian Barwick
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Manoj Soni | 2014-01-27 12:11:05 | A Simple web application |
| Previous Message | Vincent Veyron | 2014-01-27 09:56:51 | Re: fastest dump/restore |