Don't use AppContext.SetSwitch("Npgsql.EnableLegacyTimestampBehavior", true) with Hangfire.PostgreSql!

question
1

It breaks hangfire pipeline. Briefly. We faced the problem that our worker thread seems to be stuck processing jobs, but no exceptions, no errors showed in logs. Furthermore, sometimes we had our jobs succeeded, but they still sits in jobqueue as if DELETE FROM hangfire.jobqueue WHERE id = @Id AND fetchedat = @FetchedAt never satisfied. We got rid of Npgsql.EnableLegacyTimestampBehavior and everything seems to be ok now.