| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Remote troubleshooting session connection? |
| Date: | 2014-04-04 22:56:51 |
| Message-ID: | 533F38B3.1080301@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 4/4/2014 3:41 PM, Jim Garrison wrote:
> 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?
very difficult, as that data only exists in the context of the socket
the JDBC connection is using.
you maybe could do that with a JDBC tool that could 'pirate' on the same
JDBC connection your app is using, obviously when its not already in a
call. perhaps add a telnet or whatever UI to instrument your java ETL
tool to allow you to pause and run manual SQL queries on the same interface?
--
john r pierce 37N 122W
somewhere on the middle of the left coast
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lists | 2014-04-04 23:29:35 | Re: SSD Drives |
| Previous Message | Adrian Klaver | 2014-04-04 22:46:45 | Re: Remote troubleshooting session connection? |