From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Andrew Dunstan <andrew(at)dunslane(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: statement timeout vs dump/restore |
Date: | 2008-05-03 17:31:01 |
Message-ID: | 481CA155.2090300@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tom Lane wrote:
> Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
>> Do we want the following:
>
>> 1. pg_dump issues "set statement_timeout = 0;" to the database prior to
>> taking its copy of data (yes/no/default-but-switchable)
>> 2. pg_dump/pg_restore issue "set statement_timeout = 0;" in text mode
>> output (yes/no/default-but-switchable)
>> 3. pg_restore issues "set statement_timeout = 0;" to the database in
>> restore mode (yes/no/default-but-switchable)
>
> I think "yes" for all three. There was some handwaving about someone
> maybe not wanting it, but an utter lack of convincing use-cases; so
> I see no point in going to the effort of providing a switch.
>
> Note that 2 and 3 are actually the same thing (if you think they are
> not, then you are putting the behavior in the wrong place).
Right, pg_restore just using the output from pg_dump. The dump has the
statement_timeout. That way it works regardless of output (e.g; for psql
text based restores).
Sincerely,
Joshua D. Drake
>
> regards, tom lane
>
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2008-05-03 19:20:30 | Re: [COMMITTERS] pgsql: Sigh ... |
Previous Message | Tom Lane | 2008-05-03 17:17:34 | Re: [COMMITTERS] pgsql: Sigh ... |