Re: Changing pg_dump default file format

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?


> This, for example, is a valid and useful construct:
>
> pg_dump test | psql test2
>
> ... or:
>
> pg_dump -s test | psql test3
>

pg_dump -s test -fp| psql test3

> A lot of scripts will be broken by changing the default format for
> piped output.

For the sake of sanity... really?  You just proved my point. This isn't 
about developers. Developers now how to code. They can change a simple 
script. This is about production DBA/admins, the 98% of people using 
postgresql.

Joshua D. Drake

-- 
Command Prompt, Inc. - http://www.commandprompt.com/  509-416-6579
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc
For my dreams of your image that blossoms   a rose in the deeps of my heart. - W.B. Yeats