Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Patches > Re: pg_dump loc...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 9 of 12 Topic 3705 of 4098
Post > Topic >>

Re: pg_dump lock timeout

by markokr@[EMAIL PROTECTED] ("Marko Kreen") Jul 3, 2008 at 11:15 AM

On 5/11/08, daveg <daveg@[EMAIL PROTECTED]
> wrote:
>  Attached is a patch to add a commandline option to pg_dump to limit how
long
>  pg_dump will wait for locks during startup.

My quick review:

- It does not seem im****tant enough to waste a short option on.
  Having only long option should be enough.

- It would be more polite to do SET LOCAL instead SET.
  (Eg. it makes safer to use pg_dump through pooler.)

- The statement_timeout is set back with "statement_timeout = default"
  Maybe it would be better to do "= 0" here?  Although such decision
  would go outside the scope of the patch, I see no sense having
  any other statement_timeout for actual dumping.

-- 
marko

-- 
Sent via pgsql-patches mailing list (pgsql-patches@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches
 




 12 Posts in Topic:
pg_dump lock timeout
daveg@[EMAIL PROTECTED]   2008-05-11 04:30:47 
Re: pg_dump lock timeout
daveg@[EMAIL PROTECTED]   2008-05-11 06:00:35 
Re: pg_dump lock timeout
david@[EMAIL PROTECTED]   2008-07-02 08:56:26 
Re: pg_dump lock timeout
daveg@[EMAIL PROTECTED]   2008-07-16 19:44:07 
Re: pg_dump lock timeout
tgl@[EMAIL PROTECTED] (T  2008-07-20 14:50:50 
Re: pg_dump lock timeout
daveg@[EMAIL PROTECTED]   2008-07-21 00:21:31 
Re: pg_dump lock timeout
tgl@[EMAIL PROTECTED] (T  2008-07-21 03:43:11 
Re: pg_dump lock timeout
daveg@[EMAIL PROTECTED]   2008-07-21 22:57:35 
Re: pg_dump lock timeout
markokr@[EMAIL PROTECTED]  2008-07-03 11:15:10 
Re: pg_dump lock timeout
daveg@[EMAIL PROTECTED]   2008-07-03 05:55:01 
Re: pg_dump lock timeout
tgl@[EMAIL PROTECTED] (T  2008-07-03 11:33:16 
Re: pg_dump lock timeout
daveg@[EMAIL PROTECTED]   2008-07-16 05:37:36 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Oct 15 20:43:35 CDT 2008.