had same issue so change the port to 5432, even in their docs they are mentioning 6543 but this is for Transaction pooler and you need Session pooler which is 5432