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

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