Mark, Thanks so much for your help and explanation!
Yongming On Mon, Nov 28, 2016 at 11:17 AM, Mark Wood <[email protected]> wrote: > On Monday, November 28, 2016 at 8:43:12 AM UTC-5, wangyo wrote: >> >> Hi Mark, >> >> > You can change that last record from "md5" (which requires a password) >> to "trust"... >> >> I did that. >> >> Then I restarted postgresql-9.5, and ran the cammond as follows: >> >> [root@dr data]# /usr/pgsql-9.5/bin/psql -U postgres -f >> /dspace-backup/pg.out postgres >> >> The output as following: >> >> SET >> SET >> SET >> CREATE ROLE >> ALTER ROLE >> psql:/dspace-backup/pg.out:16: ERROR: role "postgres" already exists >> ALTER ROLE >> CREATE DATABASE >> REVOKE >> REVOKE >> GRANT >> GRANT >> You are now connected to database "dspace" as user "postgres". >> SET >> SET >> SET >> SET >> SET >> SET >> CREATE EXTENSION >> COMMENT >> ... >> >> ALTER TABLE >> COPY 1710 >> setval >> -------- >> 1710 >> (1 row) >> ... >> >> >> >> It keeps going like this, and the last several lines: >> >> GRANT >> You are now connected to database "template1" as user "postgres". >> SET >> SET >> SET >> SET >> SET >> SET >> COMMENT >> CREATE EXTENSION >> COMMENT >> REVOKE >> REVOKE >> GRANT >> GRANT >> >> >> Does that mean the restore is successful? >> >> > Yes, that appears to be successful. The error on line 16 is to be > expected: the DBMS already has a superuser account defined, so it cannot > be created again. That should not be a problem. > > -- > 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. > -- 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.
