update pgsql connections
Merge pull request #806 from dajohnso/tweak_pgsql_script

update pgsql connections