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
The --link argument doesn't work, either:
bash-4.1$ export LD_LIBRARY_PATH=/usr/pgsql-9.2/lib
bash-4.1$ /usr/pgsql-9.2/bin/pg_upgrade --old-datadir=/var/lib/pgsql/data
--new-datadir=/var/lib/pgsql/9.2/data --old-bindir=/usr/bin
--new-bindir=/usr/pgsql-9.2/bin --check
Performing Consistency Check
10 matches
Mail list logo
