Re: detached query?

Tim Clarke <tim.clarke@xxxxxxxxxxxxxx> · Thu, 07 May 2015 09:36:44 +0100



    We do this

    
    nohup psql -U (username) -W -f (sqlquery script) (database) 
    &&

    
    on our linux boxes all the time to run a long query or sequence of
    them. If its a scheduled job it just goes into cron and you don't
    need the "nohup" or trailing "&&". Let me know if you'd like
    me to break all that apart for you.

    
    Tim Clarke
    On 07/05/15 02:15, Melvin Davidson
      wrote:

    
      Although not a PostgreSQL utility, in Linux, you
        can use screen or tmux to establish a connection and then
        disconnect.

      
        On Wed, May 6, 2015 at 6:48 PM, David
          G. Johnston <david.g.johnston@xxxxxxxxx>
          wrote:

          
                On Wed, May 6,
                    2015 at 3:37 PM, Yves Dorfsman <yves@xxxxxxxxx> wrote:

                
                      On 9.3, is there any way to start a query, detach
                      from the server and have the

                      query keep going (long query that updates tables,
                      but nothing is returned)?

                    
                      No.  Sessions require an external client to
                      maintain its connection.
                  
                  
                    David
                      J.
                  
                  
        -- 

        
          Melvin
                  Davidson

            I reserve the right to
                fantasize.  Whether or not you 

              wish to share my
                fantasy is entirely up to you.