Hi Rudra, rudra chandana wrote: > I ve installed a new dspace 1.4,and its successfully running. already > i ve > databse stored on dspace1.3.2 on a different machine. I need to copy the > database to the new server (using pg_dumpall and psql ) ive got the > database > into dspace1.4 server. But while executing the psql -f command its > showing > errors. > I ve also used the upgrade command i.e psql -f > database_schema_13-14.sql dspace -h localhost > this also is not working.Its showing th flg. > errors. > > psql:database_schema_13-14.sql:61: ERROR: permission denied for relation > epersongroup > psql:database_schema_13-14.sql:77: NOTICE: CREATE TABLE / PRIMARY KEY > will > create implicit index "group2groupcache_pkey" for table > "group2groupcache" > psql:database_schema_13-14.sql:77: ERROR: permission denied for relation > epersongroup
One of the problems seems to be that you're running the psql command as the wrong user. You need to be logged in as the user that owns the database (probably 'dspace'). Best regards, jim ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
