How to store DateTimeOffset in PostreSQL
Ok, this appears to be a bug with DateTimeOffset in either npgsql or npgsql.EntityFramework. There appear to be several other issues logged in their issue tracker. In particular issue #542 is pretty close - but with a different exception message.
I suggest you create a new issue over there, as they are the best to help diagnose this further.