Re: Changing pg_dump default file format

On Thu, Nov 7, 2013 at 5:53 PM, Joshua D. Drake <jd(at)commandprompt(dot)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/