On Thu, Aug 14, 2014 at 09:30:13AM -0400, John Scalia wrote: > Well, it's now gotten much worse, and I really do not understand how > this is failing. I started off this morning trying to run pg_grade > with strace in the hope that I could find something hanging up, but > pg-upgrade is now failing and exiting very early. Almost immediately > after reporting "Checking cluster versions ok", it throws a SQL > command failed where it tried to create the temporary table > 'info_rels'. The error is that type "info_rels" already exists. > > My first thought was that a previous attempt had partially succeeded > and left some garbage in the new 9.3 instance. So, I deleted > everything in the 9.3 data directory and did a new initdb there, but > the problem continues to reoccur. I have since checked the old 9.2 > database, including the template1 portion, but I don't see an > info_rels table in any of these. (I checked using "select * from > pg_tables;") I'd really like to know why it's failing here. Where is > it finding this info_rels table and why can't I find it? Is it > deleting it after it spits out this error? And is this table > something that gets repeatedly created and dropped during a > pg_upgrade? Well, you managed to show me nothing, so I can't really help you further. info_rels is an internal C struture so I can't guess what is failing. I suggest you show the error, and read the message and then look in the log file it recommends, if any. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. + -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
