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?
Asked
Active
Viewed 495 times
2
d33tah
- 389
- 1
- 2
- 10
-
2Related question: Is a Postgres long-running query aborted if the connection is lost/broken? – ypercubeᵀᴹ Jun 13 '15 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 Scheffer May 26 '16 at 10:06
-
@MauricioScheffer: nope, I hadn't. I decided to use GNU Screen instead of pgadmin for this one. – d33tah May 26 '16 at 11:50