On Sun, Oct 12, 2014 at 9:11 PM, Stephen Davies <sdav...@sdc.com.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) 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
