restoring database

0
When I restore a backup from a node to a postgres used by the modeller I get warnings like: pgrestore: [archiver (db)] Error while PROCESSING TOC: pgrestore: [archiver (db)] Error from TOC entry 168; 1259 20651 TABLE administration$account dbnode-callisto-db0 pg_restore: [archiver (db)] could not execute query: ERROR: role "dbnode-callisto-db0" does not exist Command was: ALTER TABLE "administration$account" OWNER TO "dbnode-callisto-db0"; Should I do some action or can I ingnore the errors/warnings?
asked
2 answers
0

Use pg_restore with this option (since the owner information makes no sense in another environment):

-x, --no-privileges, --no-acl Prevent restoration of access privileges (grant/revoke commands).

answered
0

Also had the same issue. Used Hans feedback and managed to get Postgres working; 

Open command line window.
Go to Postgres bin folder. For example:

cd "C:\Program Files\PostgreSQL\9.6\bin"

Enter the command to restore your database. For example:

pg_restore --no-owner --no-privileges --no-acl -U <Username> -d <DBName> -1 "C:\...\db.backup" 

Where <Username>, <DBName> and filepath are replaced to match your setup.

Type password for your postgres user.

answered