add long polling to postgres plugin

[dylanlott]

Feature description

We removed the long poller as part of a refactor with the intent to refactor it back in to the new Iterator interface in the PostgreSQL plugin and with updated handling to reflect the changes made in the Plugin SDK.