From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Mike Wilson <mfwilson(at)gmail(dot)com> |
Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #6733: All Tables Empty After pg_upgrade (PG 9.2.0 beta 2) |
Date: | 2012-07-17 02:15:35 |
Message-ID: | 11927.1342491335@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
Mike Wilson <mfwilson(at)gmail(dot)com> writes:
> Just for my interest I also created a new PG 842 db (initdb) and put
> some sample data it it and successfully did a pg_upgrade from 842 ->
> 920b2. Whatever the issue is it seems to be related to my actual
> database as a sample db conversion works.
Yeah, I was suspecting that, because there's no obvious problem in the
part of pg_upgrade that your stack trace fingers.
What we need to do next is get something that one of the PG developers
can put under a microscope. What I would suggest first is doing a
"pg_dumpall -s" (ie no data) of your database, and seeing whether
loading that into 8.4 produces a database on which pg_upgrade fails.
If so, then you could send us that dump (perhaps after some sanitizing
of names) and we could have at it.
If you aren't able to create a self-contained reproducible case in this
way, the only other way forward is for you to debug it yourself or let
one of the PG developers have access to your system to poke at it.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2012-07-17 07:16:30 | Re: Re: BUG #6652: Installer grants postgres user rights for the whole disk, not specified subfolder |
Previous Message | Trey Chadick | 2012-07-16 23:01:00 | Re: BUG #6652: Installer grants postgres user rights for the whole disk, not specified subfolder |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-07-17 03:21:47 | Re: b-tree index search algorithms |
Previous Message | Tom Lane | 2012-07-17 01:58:43 | Re: CompactCheckpointerRequestQueue versus pad bytes |