No. Just pg_dump and pg_restore/postgis_restore.pl.
On 13/10/14 22:24, Vick Khera wrote:
> 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?
>
>
--
=============================================================================
Stephen Davies Consulting P/L Phone: 08-8177 1595
Adelaide, South Australia. Mobile:040 304 0583
Records & Collections Management.