| From: | Stephen Davies <sdavies(at)sdc(dot)com(dot)au> |
|---|---|
| To: | Vick Khera <vivek(at)khera(dot)org> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: 9.3 migration issue |
| Date: | 2014-10-13 23:28:43 |
| Message-ID: | 543C602B.8020306@sdc.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)sdc(dot)com(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2014-10-13 23:35:44 | Re: 9.3 migration issue |
| Previous Message | Stephen Davies | 2014-10-13 23:27:24 | Re: 9.3 migration issue |