From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Stephen Davies <sdavies(at)sdc(dot)com(dot)au>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: 9.3 migration issue |
Date: | 2014-10-13 23:35:44 |
Message-ID: | 543C61D0.2080403@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 10/13/2014 04:27 PM, Stephen Davies wrote:
> Nope. All went very smoothly apart from these grant issues.
I think what Jeff was after was any error messages related to the grant
issues. I would expect that if users where granted access to tables and
where now denied, there would be an error on restore when that GRANT was
issued.
>
> On 14/10/14 01:57, Jeff Janes wrote:
>> On Sun, Oct 12, 2014 at 9:11 PM, Stephen Davies <sdavies(at)sdc(dot)com(dot)au
>> <mailto:sdavies(at)sdc(dot)com(dot)au>> wrote:
>>
>> I am in the process of migrating several PostgreSQL databases from a
>> 32-bit V9.1.4 environment to a 64-bit V9.3 environment.
>>
>> I have used pg_dump and pg_restore (or postgis_restore.pl
>> <http://postgis_restore.pl>) as required by the combination of
>> version and
>> word size migration and the results have been (superficially) good.
>>
>> However, some tables in some databases have lost access privileges.
>> That is, users who could access tables on the old server are
>> denied access
>> on the new.
>> 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.
>>
>>
>> Did you get any error messages during the load?
>>
>> Cheers,
>>
>> Jeff
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Israel Brewster | 2014-10-13 23:40:27 | Re: Processor usage/tuning question |
Previous Message | Stephen Davies | 2014-10-13 23:28:43 | Re: 9.3 migration issue |