I hope someone can help me determine what is going on with my database.
We have released code this weekend to our application and I have switched over
to my hot standby that has been tuned and modified to raid10. It is up and
appeared come on line and pitr is running to the standby (ok)
We have also set up pgbouncer to handle all connections from applications to
the database.
We are seeing the error ( 2009-11-02 08:31:30
EST:recog...@192.168.3.153(48990):4562ERROR: current transaction is aborted,
commands ignored until end of transaction block )
consistantly in the database and I'm not sure if there was something left out
of the code ( search indicates autocomit), or pgbouncer or putting the hot
standby online, but with so many changes it's a guessing game.
It appears to be working in our RC environment.
Please help.
Sincerely,
Chris
_________________________________________________________________
Save up to 84% on Windows 7 until Jan 3—eligible CDN College & University
students only. Hurry—buy it now for $39.99!
http://go.microsoft.com/?linkid=9691635
