Search Postgresql Archives

pg_restore frozen?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux