From: saravanan <saravanan.kcse@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Importing the dump file in postgresql-7.4.23
Date: Wed, 13 Jul 2011 00:25:37 -0700 (PDT)
Message-ID: <1310541937561-4581840.post@n5.nabble.com> (raw)
In-Reply-To: <10783.1310476776@sss.pgh.pa.us>
References: <1310475278308-4578769.post@n5.nabble.com>
<10783.1310476776@sss.pgh.pa.us>
Tom Lane-2,
Thanks for your reply.
This is my first error
Initially i got error *plpgsql.so file missing*, then created symbolic link
for /usr/local/pgsql/lib from /usr/lib/postgresql/lib
First error checks for plpgsql.so files in /usr/lib/postgresql/lib. So i
created symblink.
Second error looks for $libdir/ltree. But there is no such libdir
environment variable in .bash_profile.
Notice: type 'ltree' is not yet defined
*Error : could not access file "$libdir/ltree": no such file or directory*
[postgres@oracle bin]$ pg_config --libdir
/usr/local/pgsql/lib
[postgres@oracle bin]$ pg_config --pkglibdir
/usr/local/pgsql/lib
But i have ltree directory in the following path
I have all the file here like tsearch2 and ltree. How can i map this dir to
libdir?
[postgres@oracle contrib]$ pwd
/usr/local/src/postgresql-7.4.23/contrib
I set environment variables in .bash_profile
LD_LIBRARY_PATH=/usr/local/pgsql/lib
export LD_LIBRARY_PATH
PATH=/usr/local/pgsql/bin:$PATH
export PATH
MANPATH=/usr/local/pgsql/man:$MANPATH
export MANPATH
All my library files are in /usr/local/pgsql/lib
All my tsearch2,ltree files are in /usr/local/src/postgresql-7.4.23/contrib
Any help would be appreciated
Thanks!!!
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Importing-the-dump-file-in-postgresql-7-4-23-tp4578769p45818...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
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-admin@postgresql.org
Cc: saravanan.kcse@gmail.com
Subject: Re: Importing the dump file in postgresql-7.4.23
In-Reply-To: <1310541937561-4581840.post@n5.nabble.com>
* 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