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.
