Thread: detached query?
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 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.
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.
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@gmail.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.