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

Hi Joon,

I have no source code for this contrib/lo and dll/function seem already be stored with my 8.0.13 installation package.

Any suggestion?

Regards,

NETsolutions Asia Limited   +66 2 401 9250

>>> John R Pierce <pierce@hogranch.com> 2016-03-03 09:05 >>>

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