Re: [GENERAL] fastest dump/restore
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 -- Regards, Vincent Veyron http://libremen.com/ Legal case, contract and insurance claim management software -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] fastest dump/restore
2014-01-27 Vincent Veyron vv.li...@wanadoo.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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] fastest dump/restore
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. (I want to do a prophylactic dump/restore, after a middle-of-the-day OS crash caused by a third-party in-kernel driver--which I am going to remove now.) -- Scott Ribe scott_r...@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general