From: | Jim Garrison <jim(dot)garrison(at)nwea(dot)org> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Remote troubleshooting session connection? |
Date: | 2014-04-04 22:41:28 |
Message-ID: | 0C723FEB5B4E5642B25B451BA57E2730751AAA52@S1P5DAG3C.EXCHPROD.USA.NET |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm working on an ETL system that is driven from Java/JDBC but is implemented mostly as SQL queries against a PostgreSQL database.
An ETL "job" runs inside its own transaction and consists of a series of queries that transform the data from staging tables to the destination tables. If a failure occurs, the transaction rolls back so there's no "debris" left over -- which makes troubleshooting very difficult.
In the Java world we have JPDA, which allows us to connect to a running JVM to examine the state of variables and set breakpoints, etc.
Assuming I can pause the driving Java code between queries in a job, is there any way to connect from PGAdmin (or another tool) and view the state of tables in the in-progress transaction? If this is not currently possible, how difficult would it be to do?
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2014-04-04 22:46:45 | Re: Remote troubleshooting session connection? |
Previous Message | David Boreham | 2014-04-04 22:12:00 | Re: SSD Drives |