pg_restore frozen?

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

Browse pgsql-general by date

  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