aravindhan(dot)v(at)ionidea(dot)com writes:
> PostgreSQL version: 9.3.0
If you're actually running 9.3.0 then the *first* thing to do is update to
9.3.latest. And read the release notes. There were some nasty data-loss
bugs in the earliest 9.3.x releases.
regards, tom lane