In a jar, combine the sugar, pineapple and rhum agricole. Stir to dissolve as much of the sugar as possible. Cover and refrigerate overnight. Strain into an airtight container, reserving some of the pineapple for the drink. Refrigerate for up to 1 week.