Re: statement timeout vs dump/restore

Tom Lane wrote:
> Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> writes:
>
>> ISTR being unconvinced by the pg_restore arguments, but as I think about it
>> some more, for someone to set statement_timeout on a production system, and
>> then have that be blindly overridden by any random pg_dump user seems a bit
>> unfair. pg_dump is not only used as a backup tool, it is also used as a
>> general user tool (for example, pgadmin calls pg_dump if you want to see a
>> tables schema).
>>
>
> So? In those usages, it's not going to run long enough to have a
> statement_timeout problem anyway.
>
> When there is a data dump involved, you still have to defend the
> proposition that it's okay for pg_dump to deliver a bad dump if
> statement_timeout hits it. I can't accept that.
>
>
>

I agree.

What is more, the solution to the non-dump uses of pg_dump is to put
that functionality in a library where clients can call it directly
rather than using pg_dump.

cheers

andrew