From: | "Kynn Jones" <kynnjo(at)gmail(dot)com> |
---|---|
To: | "pgsql-general General" <pgsql-general(at)postgresql(dot)org> |
Subject: | pg_restore frozen? |
Date: | 2008-06-04 16:19:40 |
Message-ID: | c2350ba40806040919v642cd231l8e3502e0d4809b81@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | debh | 2008-06-04 17:50:11 | tablespaces not working |
Previous Message | Gary Fu | 2008-06-04 15:34:10 | how to sync the system table with pg_dump |