Yup, that looks like the problem.
Doing:
postgres=# SELECT * FROM pg_auth_members
postgres-# WHERE roleid NOT IN (SELECT oid FROM pg_authid);
Yields, 11 Rows, so for sure someone must have been messing around. Thanks.
On Tue, Jun 16, 2015 at 11:58 AM, Jerry Sievers
wrote:
> Melvin Davidson wr
Melvin Davidson writes:
> Using pg_upgrade in 9.4 CentOS release 6.6 (Final) (from PostgreSQL 9.1.15)
> it fails when GRANTING permits to roles.
>
> Checking pg_upgrade_dump_globals.sql, I see the point of failure is caused by
> the -- Role memberships section.
>
> In there I see the following
Using pg_upgrade in 9.4 CentOS release 6.6 (Final) (from PostgreSQL 9.1.15)
it fails when GRANTING permits to roles.
Checking pg_upgrade_dump_globals.sql, I see the point of failure is caused
by the -- Role memberships section.
In there I see the following troublesome lines.
-- Role memberships
Charles Porter writes:
> Yep. That's it. Thank you
> Maximum data alignment: 4
> Maximum data alignment: 8
> There are several differences, including TOAST chunk 2000 vs 1996.
> I take it that this means that I cannot us pg_upgrade.
Well, not if you want the new serve
On Wed, Jan 16, 2013 at 06:47:12PM -0800, Charles Porter wrote:
> Bruce -
>
> Yep. That's it. Thank you
>
> Maximum data alignment: 4
> Maximum data alignment: 8
>
> There are several differences, including TOAST chunk 2000 vs 1996.
>
> I take it that this means th
On Wed, Jan 16, 2013 at 03:06:41PM -0800, Charles Porter wrote:
> I am trying to migrate from 8.4 to 9.2 on OSX 10.8 (Mountain Lion)
>
> Both 8.4 and 9.2 have been installed with the installers for OSX from
> EnterpriseDB
>
> Both have been stopped.
>
> As user postgres, I run the pg_upgrade com
I am trying to migrate from 8.4 to 9.2 on OSX 10.8 (Mountain Lion)
Both 8.4 and 9.2 have been installed with the installers for OSX from
EnterpriseDB
Both have been stopped.
As user postgres, I run the pg_upgrade command and get the error
'old and new pg_controldata alignments are invalid or do
hi
I have 8.3.11 database, ~ 600GB in size.
I want to upgrade it to 9.0.
First, I tried with 9.0.4, and when I hit problem (the same) I tried
git, head of 9.0 branch.
So. I did pg_upgrade with -c, and it looked like this:
$ time pg_upgrade -c -v -b /opt/pgsql-8.3.11-int/bin/ -B
/opt/pgsql-9.0
