Adding & dropping a column resolved the problem. Currently vacuuming the
new cluster. Thanks for your help everybody!
On Sat, May 11, 2013 at 4:58 PM, Bruce Momjian wrote:
> On Fri, May 10, 2013 at 08:03:38PM -0400, Bruce Momjian wrote:
> > On Fri, May 10, 2013 at 12:36:21PM
If it's of any value, here's the create statements for the table from the
pg_upgrade logs:
--
-- Name: setupinfo; Type: TABLE; Schema: bpm; Owner: postgres; Tablespace:
--
-- For binary upgrade, must preserve pg_type oid
SELECT binary_upgrade.set_next_pg_type_oid('17306'::pg_catalog.oid);
--
ote:
> On Thu, May 9, 2013 at 05:41:39PM -0400, Evan D. Hoffman wrote:
>> I believe the history of this cluster is that it started on 9.0 and
>> was upgraded to 9.1 via pg_upgrade. The instance I'm working on was
>> created as a streaming replica, then I broke the replicati
I believe the history of this cluster is that it started on 9.0 and was
upgraded to 9.1 via pg_upgrade. The instance I'm working on was created as a
streaming replica, then I broke the replication to make it a standalone master
specifically for testing pg_upgrade to 9.2.
On May 9, 2013, at 5:2
s:
"setupinfo_clientid_fkey" FOREIGN KEY (clientid) REFERENCES
control.client(id)
Has OIDs: no
db=#
On Thu, May 9, 2013 at 4:24 PM, Tom Lane wrote:
> "Evan D. Hoffman" writes:
> > Looks like your guess was correct:
>
> Could we see the full schema (eg psql \d+) for setupinfo?
>
> regards, tom lane
>
Looks like your guess was correct:
[ehoffman@dev-db2 ~]$ psql -Upostgres db -p 5433
psql (9.2.4)
Type "help" for help.
db=# SELECT oid, relname, reltoastrelid, reltoastidxid FROM pg_class
db-# WHERE reltoastrelid = 299749;
oid | relname | reltoastrelid | reltoastidxid
---
1 row)
db=#
On Thu, May 9, 2013 at 3:29 PM, Bruce Momjian wrote:
> On Thu, May 9, 2013 at 03:23:20PM -0400, Evan D. Hoffman wrote:
> > I just did the whole process over from the beginning. here's the full
> output:
> >
> > Copying user relation files
> >
db=# SELECT relname, relfilenode, relkind from pg_class where oid = 299749;
relname | relfilenode | relkind
+-+-
pg_toast_17304 | 299749 | t
(1 row)
db=#
On Thu, May 9, 2013 at 10:45 AM, Bruce Momjian wrote:
> On Thu, May 9, 2013 at 10:20:12AM
wrote:
> On Wed, May 8, 2013 at 02:27:18PM -0400, Evan D. Hoffman wrote:
>> If you want to start the old cluster, you will need to remove
>> the ".old" suffix from /var/lib/pgsql/9.1/data/global/pg_control.old.
>> Because "link" mode was used, the old c
