detached query?

On Wed, May 6, 2015 at 3:37 PM, Yves Dorfsman <yves@zioup.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.
​

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@gmail.com> wrote:

On Wed, May 6, 2015 at 3:37 PM, Yves Dorfsman <yves@zioup.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.

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