developer@xxxxxxxxxxxx writes:
could do logging wise on the postgres side to get a better indication of what is happening?
You can increase the levels of loggin and redirect std_error to a file. Something along the lines of log_destination = 'stderr' log_filename = 'postgresql-%Y-%m-%d.log' log_error_verbosity = verbose log_min_error_statement = debug1 log_min_messages = info
