updates to use pg in all environments