Skip site navigation (1) Skip section navigation (2)

Re: [PERFORM] user defined data type problem while dumping?

From: Alexander Borkowski <alexander(dot)borkowski(at)abri(dot)une(dot)edu(dot)au>
To: sarlav kumar <sarlavk(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [PERFORM] user defined data type problem while dumping?
Date: 2004-12-28 23:58:06
Message-ID: 41D1F30E.7060007@abri.une.edu.au (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-performance
Hi Saranya,

> psql:trialdump1:4364: ERROR:  could not access file "/usr/local/pgsql/lib/contrib/lo.so": No such file or directory
> psql:trialdump1:4403: ERROR:  could not access file "/usr/local/pgsql/lib/contrib/lo.so": No such file or directory

It looks like you need to install the lo library on the machine you are 
trying to restore to. It contains the implementation for the type you 
are missing and it is not installed by default. You can find it in the 
contrib section of the PostgreSQL source tree.

> psql:trialdump1:4472: ERROR:  could not access file "/usr/lib/test_funcs.so": No such file or directory

Don't know about this one, but this may be a similar problem (i.e. file 
exists on the machine you dumped from but not on the one you try to 
restore to).

> What could the problem be? Is it some sort of access rights problem with respect to the files it is not able to access? 

If this was an access permission problem you would probably get 
'Permission denied' instead of 'No such file or directory' in the error 
messages.

HTH,

Alex

In response to

pgsql-novice by date

Next:From: Robert TreatDate: 2004-12-29 03:57:28
Subject: Re: [PERFORM] slony replication
Previous:From: boydDate: 2004-12-28 21:59:50
Subject: Re: help with - psql: FATAL: Password authentication failed for user "gforge"

pgsql-performance by date

Next:From: Robert TreatDate: 2004-12-29 03:57:28
Subject: Re: [PERFORM] slony replication
Previous:From: IainDate: 2004-12-28 04:56:42
Subject: Re: Howto Increased performace ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group