On Thu, Nov 7, 2013 at 5:53 PM, Joshua D. Drake <j...@commandprompt.com> wrote: > > On 11/07/2013 08:21 AM, Kevin Grittner wrote: > >>> I humbly request on behalf of those who manage production postgresql >>> instances that we change the default backup file format from -Fp to -Fc. >> >> >> -1 in the case that output goes to stdout. It might make sense for >> when -f is specified. As a DBA, 90% of my usage of pg_dump was >> piped to psql, with the rest split between data-only dumps for >> individual tables and schema-only dumps. I think I used -Fc about >> twice -- before I figured out how to do PITR-style backups. >> > > PITR is wonderful, I use it all the time. It has exactly zero to do with > what we are talking about. We are talking about pg_dump and its usefulness. > Are you suggesting that we tell people to not use pg_dump and instead use > PITR?
For backups, absolutely. That is, assuming you mean "pg_basebackup -x", and not full archive_command/full pitr setup. That's still a separate argument, of course. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
