Postgresql db import not working well

Question

I am trying to import a sql dump to postgresql db as -

sudo su postgres -c psql dbname < mydb_dump.sql

This gives errors as -


SET
SET
SET
SET
SET
SET
ERROR:  function "array_accum" already exists with same argument types
ALTER AGGREGATE
ERROR:  function "c" already exists with same argument types
ALTER AGGREGATE
ERROR:  duplicate key value violates unique constraint "pg_ts_config_cfgname_index"
ERROR:  duplicate key value violates unique constraint "pg_ts_config_map_index"

and so on this. What might be wrong with that? Tried googling for it, but couldn't find any pointers over it.

Postgresql version is 8.4.1

Thanks !!

Does : http://stackoverflow.com/questions/1797954/postgresql-database-restore-from-dump-syntax-error/1798028#1798028 help? — Kai Huppmann, Dec 15 '11 at 12:20
Kai's comment did helped. Different command users there worked nice !! — rtdp, Dec 15 '11 at 20:54

score 1 · Answer 1 · answered Dec 15 '11 at 13:38

you should to remove shared functions and objects from database, before you do dump or before you load dump. You have these functions and objects registered in template1, and when you create new database, then these objects are there - and you can see errors when dump try to create it again.

This issue is well solved in PostgreSQL 9.1. For older versions try to use option --clean for pg_dump

Pavel

Postgresql db import not working well

1 Answers1