Re: [ADMIN] Importing the dump file in postgresql-7.4.23

2011-07-15 Thread saravanan
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

[ADMIN] 'ERROR: Permission denied for schema' while importing dump

2011-07-14 Thread saravanan
Hi all, I'm using PostgreSQL - 8.0.0 version. I tried to importing dumps but i'm getting the following error . 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 can avoid some errors. But i'

Re: [ADMIN] Importing the dump file in postgresql-7.4.23

2011-07-13 Thread saravanan
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

[ADMIN] Importing the dump file in postgresql-7.4.23

2011-07-12 Thread saravanan
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