Postgresql db update race condition

[rjshrjndrn]

Ref: https://github.com/project-sunbird/sunbird-community/discussions/171#discussioncomment-615232

It seems like postgresqldb update job fails in b/w

CREATE INDEX
CREATE INDEX
COMMIT

STDERR:

psql:/tmp/tables_postgres.sql:181: WARNING: there is no transaction in progress

MSG:

Dump of database quartz failed

It seems like the ansible Postgres module is creating additional sessions. Have to dig deep to figure out, why this is happening.