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 Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
