updated pg adapter for production database