Dear Mark, I did this :-
root@DSpace:~# psql --user dspace -d dspace -f /home/dspace/dspace-install/etc/postgres/update-sequences.sql psql: FATAL: Peer authentication failed for user "dspace" root@DSpace:~# Can you please correct me ? Thank you, Ashim On Mon, 9 Mar 2020 at 20:50, Mark H. Wood <[email protected]> wrote: > 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 > . > -- 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/CAGEJAoEYUo-PvM0GYph-j0AmXR68C9M4VxK_kbfjMP2cqc8Udg%40mail.gmail.com.
