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 Hackers > statement timeo...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 8 Topic 9300 of 9628
Post > Topic >>

statement timeout vs dump/restore

by andrew@[EMAIL PROTECTED] (Andrew Dunstan) May 3, 2008 at 09:50 AM

I'm a bit confused about where the consensus is on this issue ( 
http://archives.postgresql.org/message-id/20080311110727.62605f5f@[EMAIL
PROTECTED]
 al)

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 would tend to say default-but-switchable for all 3, but maybe that's 
too complicated.

cheers

andrew

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




 8 Posts in Topic:
statement timeout vs dump/restore
andrew@[EMAIL PROTECTED]   2008-05-03 09:50:30 
Re: statement timeout vs dump/restore
tgl@[EMAIL PROTECTED] (T  2008-05-03 13:01:36 
Re: statement timeout vs dump/restore
jd@[EMAIL PROTECTED] (&q  2008-05-03 10:31:01 
Re: statement timeout vs dump/restore
Andreas.Zeugswetter@[EMAI  2008-05-05 12:38:54 
Re: statement timeout vs dump/restore
andrew@[EMAIL PROTECTED]   2008-05-05 09:01:25 
Re: statement timeout vs dump/restore
xzilla@[EMAIL PROTECTED]   2008-05-06 16:51:13 
Re: statement timeout vs dump/restore
tgl@[EMAIL PROTECTED] (T  2008-05-06 17:33:13 
Re: statement timeout vs dump/restore
andrew@[EMAIL PROTECTED]   2008-05-06 17:56:53 

Post A Reply:
  Go here to Signup

AddThis Feed Button


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

Contact
tan13V112 Fri Jul 4 9:46:18 CDT 2008.