Re: Re: could not migrate 8.0.13 database with large object data to 9.5.1

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Re: could not migrate 8.0.13 database with large object data to 9.5.1
Date: 2016-03-03 02:05:03
Message-ID: 56D79BCF.6000002@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3/2/2016 5:52 PM, Premsun Choltanwanich wrote:
>
> And, almost tables are transferred to new server except tables which
> contain lo data (all those tables are missing from the database) after
> running pg_dump and psql following as per your suggestion.
>
> The attachment is a log file created after all processes are completed.

your logfile shows a bunch of custom functions being defined which are
dependent on a missing binary library, apparently your previous install
of postgres has some customizations.

> 2016-03-02 18:06:25 ICT ERROR: could not find function "lo_in" in file "C:/Program Files/PostgreSQL/9.5/lib/lo.dll"
> 2016-03-02 18:06:25 ICT STATEMENT: CREATE FUNCTION lo_in(cstring) RETURNS lo
> LANGUAGE c IMMUTABLE STRICT
> AS '$libdir/lo', 'lo_in';

these custom functions are being used to define a custom data type.

> 2016-03-02 18:06:25 ICT ERROR: function lo_in(cstring) does not exist
> 2016-03-02 18:06:25 ICT STATEMENT: CREATE TYPE lo (
> INTERNALLENGTH = 4,
> INPUT = lo_in,
> OUTPUT = lo_out,
> ALIGNMENT = int4,
> STORAGE = plain
> );

and your tables are using this custom data type 'lo', which is invalid
since the code to implement it is missing.

> 2016-03-02 18:06:26 ICT ERROR: type "lo" is only a shell at character 186
> 2016-03-02 18:06:26 ICT STATEMENT: CREATE TABLE t_familypic (
> sysid bigint DEFAULT nextval('public.t_familypic_sysid_seq'::text) NOT NULL,
> mbrsysid bigint NOT NULL,
> familysysid bigint NOT NULL,
> familypic lo
> );

do you have the source code to this lo.dll so you can be rebuild it for
9.5 ?

--
john r pierce, recycling bits in santa cruz

In response to

Browse pgsql-general by date

  From Date Subject
Next Message david 2016-03-03 05:36:34 Re: CStringGetTextDatum and other conversions in server-side code
Previous Message Joe Conway 2016-03-03 02:00:36 Re: CStringGetTextDatum and other conversions in server-side code