statement timeout vs dump/restore - Mailing list pgsql-hackers

From Andrew Dunstan
Subject statement timeout vs dump/restore
Date
Msg-id 481C6DA6.80905@dunslane.net
Whole thread Raw
Responses Re: statement timeout vs dump/restore  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I'm a bit confused about where the consensus is on this issue ( 
http://archives.postgresql.org/message-id/20080311110727.62605f5f@commandprompt.com 
et 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


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: ecpg localization
Next
From: Tom Lane
Date:
Subject: Re: statement timeout vs dump/restore