From: Alexander Borkowski <alexander.borkowski@abri.une.edu.au>
To: sarlav kumar <sarlavk@yahoo.com>
Cc: pgsql-novice@postgresql.org
Subject: Re: [PERFORM] user defined data type problem while dumping?
Date: Wed, 29 Dec 2004 10:58:06 +1100
Message-ID: <41D1F30E.7060007@abri.une.edu.au> (raw)
In-Reply-To: <20041227173233.98750.qmail@web51301.mail.yahoo.com>
References: <20041227173233.98750.qmail@web51301.mail.yahoo.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: alexander.borkowski@abri.une.edu.au, sarlavk@yahoo.com, pgsql-novice@postgresql.org
Subject: Re: [PERFORM] user defined data type problem while dumping?
In-Reply-To: <41D1F30E.7060007@abri.une.edu.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox