On Fri, Jul 15, 2011 at 1:11 AM, saravanan wrote:
> Hi,
>
> I tried to troubleshoot the errors while importing dumps in PostgreSQL -
> 8.0.0 version. But still i'm getting some permission level errors. Before
> importing the dumps, i used to install some functions like
> ltree,tsearch2,pgcrypto fr
Hi,
I tried to troubleshoot the errors while importing dumps in PostgreSQL -
8.0.0 version. But still i'm getting some permission level errors. Before
importing the dumps, i used to install some functions like
ltree,tsearch2,pgcrypto from directory
/usr/local/src/postgresql-8.0/contrib. So that i
saravanan writes:
> [postgres@oracle bin]$ pg_config --libdir
> /usr/local/pgsql/lib
> [postgres@oracle bin]$ pg_config --pkglibdir
> /usr/local/pgsql/lib
> I set environment variables in .bash_profile
> LD_LIBRARY_PATH=/usr/local/pgsql/lib
> export LD_LIBRARY_PATH
That would only help if it we
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 lo
saravanan writes:
> I'm using PostgreSQL-7.4.23 version. I have one dump file that was taken
> using pg_dumpall utility. Now i tried to import the dump file. But its
> throwing me lot of *Invalid Command \N error* , *ERROR: type tsvector does
> not exist* and *\t: extra argument "string" ignored
is your target DB >=8.x?
Did you use to have tsearch2 installed in 7.4?
Anyway, this is how we used to dump from 7.4 and load into 8.3:
take the dump from 7.4,
install 8.3
initdb, etc...
cd /usr/local/src/postgresql-8.3.3
cd contrib/tsearch2/
make uninstall
cd ../intarray/
make uninstall
create
Hi all,
I'm using PostgreSQL-7.4.23 version. I have one dump file that was taken
using pg_dumpall utility. Now i tried to import the dump file. But its
throwing me lot of *Invalid Command \N error* , *ERROR: type tsvector does
not exist* and *\t: extra argument "string" ignored error*
I'm using
