Unix Technical Forum

pg_restore frozen?

This is a discussion on pg_restore frozen? within the Pgsql General forums, part of the PostgreSQL category; --> When I try to run pg_restore (as the postgres superuser), it appears to freeze after printing the following: pg_restore ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > Pgsql General

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 06-04-2008, 06:01 PM
Kynn Jones
 
Posts: n/a
Default pg_restore frozen?

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 10:07 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com