chore(core): add PostgreSQL connection tests