On 04/04/2014 03:41 PM, Jim Garrison wrote:
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.
Why not crank up the logging in postgresql.conf and then look at the
postgres logs?
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?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
