Dear all, One of the DSpace 6.0 pre-requisites is PostgreSQL 9.4 or above. My current DSpace 5.1 installation has PostgreSQL 9.2. So I have to upgrade my PostgreSQL first in order to upgrade to DSpace 6.0. My OS is RHEL 7.
I installed PostgreSQL 9.5 by using rpm and yum. The installed directory is /usr/pgsql-9.5 (the default). My PostgreSQL 9.2 is at /usr/share/pgsql. Before I installed PostgreSQL 9.5, I used pg_dumpall to backup the PostgreSQL 9.2 to a file named pg.out. After I installed PostgreSQL 9.5, I tried to restore my backup file by using psql like this: # /usr/pgsql-9.5/bin/psql -f /dspace-backup/pg.out postgres Password: I got the following error: psql: FATAL: password authentication failed for user "root" I tried all different passwords, but the same error every time. What is the cause for this error? How do I solve it? I did two things before doing the above restore procedure: 1. Edit /var/lib/pgsql/data/9.5/postgresql.conf Uncomment the line: listen_addresses = ‘localhost’ 2. Edit /var/lib/pgsql/data/9.5/pg_hba.conf Add the line: host dspace dspace 127.0.0.1 255.255.255.255 md5 Change: “local all all peer” to “local all all md5” My other questions are: Do I have to backup my PostgreSQL 9.2 and restore it to PostgreSQL 9.5? Or rather, do I have to upgrade to PostgreSQL 9.4 or above? I'm not familiar with PostgreSQL at all. Any help and guidance will be greatly appreciated! Yongming -- Yongming Wang Systems Librarian/Associate Professor The College of New Jersey tel: 609-771-3337 email: [email protected] -- You received this message because you are subscribed to the Google Groups "DSpace Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/dspace-community. For more options, visit https://groups.google.com/d/optout.
