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@xxxxxxxxxx
<mailto:sdavies@xxxxxxxxxx>> 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.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
