pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (3+ messages)

Message-ID: <41D1F30E.7060007@abri.une.edu.au>
Permalink:  ../41D1F30E.7060007@abri.une.edu.au/
Also on:    postgresql.org/message-id/41D1F30E.7060007@abri.une.edu.au

 · 

reply

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