Dear Ashim, "Peer authentication failed" means your PostgreSQL user could not log in. Either the password was wrong, the user doesn't exist, or you have incorrectly configured the "allowed" IPs / databases for that user in pg_hba.conf. On my Ubuntu system the file is here: /etc/postgresql/9.6/main/pg_hba.conf
Are you sure you have a "dspace" user in PostgreSQL? Check the DSpace wiki for more information about the correct settings for pg_hba.conf: https://wiki.lyrasis.org/display/DSDOC6x/Installing+DSpace#InstallingDSpace-RelationalDatabase:(PostgreSQLorOracle) Cheers, On Wed, Mar 11, 2020 at 8:25 AM Ashim Kapoor <[email protected]> wrote: > 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 > <https://groups.google.com/d/msgid/dspace-tech/CAGEJAoEYUo-PvM0GYph-j0AmXR68C9M4VxK_kbfjMP2cqc8Udg%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- Alan Orth [email protected] https://picturingjordan.com https://englishbulgaria.net https://mjanja.ch -- 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/CAKKdN4XKotNr-HDRXNKqrFyEjmreAWpUdumcXkt9muqdoAG%2B%2Bw%40mail.gmail.com.
