Adrian Klaver writes:
> On 01/01/2014 12:45 PM, Reiser, John J. wrote:
>> Thanks for the info. After searching the output for the connection string,
>> I found that it's failing on a database that can be archived. I think I'll
>> get what I need from the database, drop it, then perform the upgrade
On 01/01/2014 12:45 PM, Reiser, John J. wrote:
On 1/1/14, 3:37 PM, "Tom Lane" wrote:
Could you look at the text surrounding these places to determine which
types this OID is being selected for? Each of these calls should be just
preceding a CREATE TYPE command (with maybe a set_next_array
On 1/1/14, 3:37 PM, "Tom Lane" wrote:
>"Reiser, John J." writes:
>> On 1/1/14, 12:38 PM, "Tom Lane" wrote:
>>> What this smells like is a bug in the pg_dump --binary_upgrade logic
>>>that
>>> tries to preserve type OIDs from the old installation to the new one.
>>> Is there a preceding CREATE
"Reiser, John J." writes:
> On 1/1/14, 12:38 PM, "Tom Lane" wrote:
>> What this smells like is a bug in the pg_dump --binary_upgrade logic that
>> tries to preserve type OIDs from the old installation to the new one.
>> Is there a preceding CREATE TYPE command for st_envelope in the dump
>> scrip
On 1/1/14, 12:38 PM, "Tom Lane" wrote:
>"Reiser, John J." writes:
>> I'm working on an upgrade to our database cluster, attempting to move
>>from 8.4 to 9.2. I'm encountering the following error when I attempt the
>>upgrade (in pg_upgrade_restore.log):
>
>> CREATE FUNCTION "st_envelope_in"(cstri
"Reiser, John J." writes:
> I'm working on an upgrade to our database cluster, attempting to move from
> 8.4 to 9.2. I'm encountering the following error when I attempt the upgrade
> (in pg_upgrade_restore.log):
> CREATE FUNCTION "st_envelope_in"(cstring) RETURNS st_envelope
> LANGUAGE "c"
Adrian,
On 1/1/14, 12:26 PM, "Adrian Klaver" wrote:
>On 01/01/2014 09:08 AM, Reiser, John J. wrote:
>> The --link argument doesn't work, either:
>>
>
>>
>> Consult the last few lines of "pg_upgrade_restore.log" for
>> the probable cause of the failure.
>> Failure, exiting
>> bash-4.1$ tail -n 2
On 01/01/2014 09:08 AM, Reiser, John J. wrote:
The --link argument doesn't work, either:
Consult the last few lines of "pg_upgrade_restore.log" for
the probable cause of the failure.
Failure, exiting
bash-4.1$ tail -n 20 pg_upgrade_restore.log
(1 row)
CREATE TYPE "spheroid" (
INTERNALL
On 01/01/2014 08:53 AM, Reiser, John J. wrote:
Hello,
I'm working on an upgrade to our database cluster, attempting to move
from 8.4 to 9.2. I'm encountering the following error when I attempt the
upgrade (in pg_upgrade_restore.log):
CREATE FUNCTION "st_envelope_in"(cstring) RETURNS st_enve
John
From: , John Reiser mailto:rei...@rowan.edu>>
Date: Wednesday, January 1, 2014 at 11:53 AM
To: "pgsql-general@postgresql.org<mailto:pgsql-general@postgresql.org>"
mailto:pgsql-general@postgresql.org>>
Subject: [GENERAL] duplicate OID issue when using pg_upgrade
Hello,
I'm working on an upgrade to our database cluster, attempting to move from 8.4
to 9.2. I'm encountering the following error when I attempt the upgrade (in
pg_upgrade_restore.log):
CREATE FUNCTION "st_envelope_in"(cstring) RETURNS st_envelope
LANGUAGE "c" IMMUTABLE STRICT
AS 'st_g
11 matches
Mail list logo
