Nope. All went very smoothly apart from these grant issues. 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
-- ============================================================================= Stephen Davies Consulting P/L Phone: 08-8177 1595 Adelaide, South Australia. Mobile:040 304 0583 Records & Collections Management. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
