All the bars recommended here will do the trick

If you're looking for upscale I would recommend Bix without hesitation. Yes, it is in a dark alley. Other non-touristy bars in North Beach that I would go for...

Basque Hotel - hip, hidden away on Romolo St
Specks - locals almost exclusively, on Columbus
I forget the name of the place, a cigar bar by the end on Montgomery, a couple steps from Enrico's
Savoy Tivoli and other bars near Grant and Green

in SOMA, Gordon Biersh (or whatever it is called) and Palomino is where all the employees from the Gap and Banana hang out.
Momo's before a Giants game (few of those left)

... and yes, the ever-popular Irish Bank