added postgres secondary validation process