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.
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)?
Thanks.
--
http://yves.zioup.com
gpg: 4096R/32B0F416
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
On Wed, May 6, 2015 at 3:37 PM, Yves Dorfsman 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
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 wrote:
On Wed, May 6, 2015 at 3:37 PM, Yves Dorfsman y...@zioup.com wrote:
On 9.3, is there any