It's been a terrifying night for some residents of the NSW north coast who had to get up on their roofs because floodwaters were coming through their homes.