When I try to run pg_restore (as the postgres superuser), it appears to
freeze after printing the following:
pg_restore -U yours_truly -d somedb /path/to/somedb.dmp
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 24; 1255 365299855 FUNCTION
epoch() postgres
pg_restore: [archiver (db)] could not execute query: ERROR: must be member
of role "postgres"
Command was: ALTER FUNCTION public.epoch() OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 25; 1255 365299853 FUNCTION
start_timer() postgres
pg_restore: [archiver (db)] could not execute query: ERROR: must be member
of role "postgres"
Command was: ALTER FUNCTION public.start_timer() OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 27; 1255 365299856 FUNCTION
stop_timer() postgres
pg_restore: [archiver (db)] could not execute query: ERROR: must be member
of role "postgres"
Command was: ALTER FUNCTION public.stop_timer() OWNER TO postgres;
If I connect to the newly restored DB, I see that all the right tables have
created, but I don't have any other way to test whether pg_restore is done
or not.
The database being restored is not so gigantic that it should take this long
for pg_restore to finish.
Is there any way to determine if something went wrong, before Ctrl-C'ing the
process? Alternatively, is there an easy way to determine if the database
has been fully restored?
TIA!
Kynn
