On Mon, Oct 13, 2014 at 12:11 AM, Stephen Davies <sdavies@sdc.com.au> wrote:
> I have fixed this by manually granting access where necessary but wonder
> whether the original issue is a bug or something that I have missed in the
> migration.
pg_dump emits the necessary GRANTs for the tables.
Did you use pg_dumpall --globals-only to copy over your users and
their settings?