a snoty nose

A runny nose that is a result from over drinking

a snoty nose - “I had a snotty nose and know I knows not to over drink”