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.johns...@gmail.com <mailto:david.g.johns...@gmail.com>> wrote: > > On Wed, May 6, 2015 at 3:37 PM, Yves Dorfsman <y...@zioup.com > <mailto:y...@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.
