[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

pg_restore in postgresql for restoring users

Posted on 2006-04-10
1
Medium Priority
?
977 Views
Last Modified: 2010-05-18
I am testing a backup of a postgres database.  It was backed up using a Fc option and I am using pg_restore to restore the database.  The original database is on a web site and I am restoring to a local database for test purposes.  I use a command like pg_restore -d fsn postgresql-fsn-7* to do the restore. Spot checking, the relations and data is restored, but the users are not.  How do I get the users to restore? Here is the tail of the error messages:

pg_restore: [archiver (db)] could not execute query: ERROR:  user "changegroupupdate" does not exist
    Command was: GRANT SELECT,UPDATE,DELETE ON TABLE groups TO changegroupupdate;
pg_restore: [archiver (db)] Error from TOC entry 49; 0 32623 ACL activities rootpg_restore: [archiver (db)] could not execute query: ERROR:  user "addactivitylog" does not exist
    Command was: GRANT INSERT,SELECT ON TABLE activities TO addactivitylog;
pg_restore: [archiver (db)] Error from TOC entry 55; 0 32623 ACL activities_activityid_seq root
pg_restore: [archiver (db)] could not execute query: ERROR:  user "addactivitylog" does not exist
    Command was: GRANT ALL ON TABLE activities_activityid_seq TO addactivitylog;pg_restore: [archiver (db)] Error from TOC entry 51; 0 32629 ACL activityservice root
pg_restore: [archiver (db)] could not execute query: ERROR:  user "addactivitylog" does not exist
    Command was: GRANT INSERT ON TABLE activityservice TO addactivitylog;
WARNING: errors ignored on restore: 294
0
Comment
Question by:astar666
1 Comment
 
LVL 62

Accepted Solution

by:
gheist earned 1000 total points
ID: 16429224
Users are not part of database.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Best database to use for Maps is PostgreSQL. This is an open source database. Comes as a package with most Linux OS. For more info visit the following site: http://www.postgresql.org/ (http://www.postgresql.org/) This requires some add-o…
Many developers have database experience, but are new to PostgreSQL. It has some truly inspiring capabilities. I have several years' experience with Microsoft's SQL Server. When I began working with MySQL, I wanted a quick-reference to MySQL (htt…
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Suggested Courses
Course of the Month19 days, 23 hours left to enroll

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question