Melvin Davidson melvin6...@gmail.com 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
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
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 gsiever...@comcast.net
wrote:
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 that I
Charles Porter charles.por...@gmail.com 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
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
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 command
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
