I just discovered pgAdmin III and I am absolutely overwhelmed by the number of options it offers. I'd like to try to replace my traditional workflow (psql
ran over an SSH session) with this tool. The problem is that I usually work on a hundred-million-row database and some of the queries I run hours or even days to complete. During that time, I'd like to be able to turn my client PC off. Does pgAdmin III support this workflow?
-
2Related question: Is a Postgres long-running query aborted if the connection is lost/broken?– ypercubeᵀᴹJun 13, 2015 at 19:06
-
Have you ever figured a way around this? I'm thinking of using pgagent and storing the result of these long queries in "temporary" tables.– Mauricio SchefferMay 26, 2016 at 10:06
-
@MauricioScheffer: nope, I hadn't. I decided to use GNU Screen instead of pgadmin for this one.– d33tahMay 26, 2016 at 11:50