Re: detached query?

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(dot)g(dot)johnston(at)gmail(dot)com <mailto:david(dot)g(dot)johnston(at)gmail(dot)com>> wrote:
>
> On Wed, May 6, 2015 at 3:37 PM, Yves Dorfsman <yves(at)zioup(dot)com
> <mailto:yves(at)zioup(dot)com>>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.