X-Original-To: pgsql-novice-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A1BDD3ABFCA for ; Tue, 28 Dec 2004 23:58:29 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 99722-10 for ; Tue, 28 Dec 2004 23:58:13 +0000 (GMT) Received: from mailhub1.une.edu.au (mailhub.une.edu.au [129.180.1.122]) by svr1.postgresql.org (Postfix) with ESMTP id 9BDDD3A62CE for ; Tue, 28 Dec 2004 23:58:07 +0000 (GMT) Received: from icarus.une.edu.au (icarus.une.edu.au [129.180.47.120]) by mailhub1.une.edu.au (Postfix) with ESMTP id 812A37F60; Wed, 29 Dec 2004 10:58:06 +1100 (EST) Received: from [129.180.47.61] ([129.180.47.61]) by icarus.une.edu.au (8.12.8/8.12.8) with ESMTP id iBSNw6T3030576; Wed, 29 Dec 2004 10:58:06 +1100 Message-ID: <41D1F30E.7060007@abri.une.edu.au> Date: Wed, 29 Dec 2004 10:58:06 +1100 From: Alexander Borkowski Organization: Agricultural Business Research Institute User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: sarlav kumar Cc: pgsql-novice@postgresql.org Subject: Re: [PERFORM] user defined data type problem while dumping? References: <20041227173233.98750.qmail@web51301.mail.yahoo.com> In-Reply-To: <20041227173233.98750.qmail@web51301.mail.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/267 X-Sequence-Number: 11844 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