On Mon, Mar 09, 2020 at 12:38:57PM +0530, Ashim Kapoor wrote: > Here is what I did: > > 1. I did an AIP backup and restore of a top level community. > 2. Looks ok in the browser after restarting tomcat. > 3. Then I stopped tomcat and as root did > [dspace]/etc/postgresql/update-sequences.sql > > It says Permission denied. > > I am root, how can I get permission denied? Can some one please help me ?
Because the shell will not execute a command or script which does not have the executable bit set in its mode, even if you are root. Also: that is not an executable command or shell script; it is an SQL script. You need to give it to an SQL interpreter. For PostgreSQL that would be 'psql'. The DBMS has its own credentials and permissions, and doesn't give special powers to 'root'. As any OS user, use the database username and password that you configured in [dspace]/config/local.cfg when running 'psql': psql --user dspace --dbname dspace --file [dspace]/etc/postgres/update-sequences.sql Password: secret See https://wiki.lyrasis.org/display/DSDOC6x/Upgrading+DSpace#UpgradingDSpace-UpgradeSteps step 11b. -- Mark H. Wood Lead Technology Analyst University Library Indiana University - Purdue University Indianapolis 755 W. Michigan Street Indianapolis, IN 46202 317-274-0749 www.ulib.iupui.edu -- All messages to this mailing list should adhere to the DuraSpace Code of Conduct: https://duraspace.org/about/policies/code-of-conduct/ --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/20200309152004.GD20427%40IUPUI.Edu.
signature.asc
Description: PGP signature
