Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Novice > warnings restor...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 10 of 12 Topic 3026 of 3255
Post > Topic >>

warnings restoring a db

by coder@[EMAIL PROTECTED] (Raimon Fernandez) Apr 9, 2008 at 08:59 AM

Helo,


I'm trying to back-up a PostgreSQL wich is installed on a remote  
windows machine.

At this moment, I'm doing a back-up with pgAmind3 1.8.2 rev. 7032 from  
OS X, selecting the db and then BackUp with the 'compress' option.

Later, with this file, I do a restore on my local copy of postgresql,  
but first I have to delete the database and create a new empty one,  
then I can Restore the backup.

It seems that all the data is there, but I have some warnings like  
those, wich I don't really know what they mean ...

....
pg_restore: creating FUNCTION pldbg_abort_target(integer)
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 21; 1255 16419  
FUNCTION pldbg_abort_target(integer) postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  could not  
access file "$libdir/pldbgapi": No such file or directory
     Command was: CREATE FUNCTION pldbg_abort_target(session integer)  
RETURNS SETOF boolean
     AS '$libdir/pldbgapi', 'pldbg_abort_target'
   ...
pg_restore: [archiver (db)] could not execute query: ERROR:  function  
public.pldbg_abort_target(integer) does not exist
     Command was: ALTER FUNCTION public.pldbg_abort_target(session  
integer) OWNER TO postgres;
pg_restore: creating FUNCTION pldbg_attach_to_****t(integer)
pg_restore: [archiver (db)] Error from TOC entry 22; 1255 16420  
FUNCTION pldbg_attach_to_****t(integer) postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  could not  
access file "$libdir/pldbgapi": No such file or directory
     Command was: CREATE FUNCTION pldbg_attach_to_****t(****tnumber  
integer) RETURNS integer
     AS '$libdir/pldbgapi', 'pldbg_attach_to_****t'
  ...

and so on till 40 warnings ...

do I have to worry about them ?

thanks,


raimon


-- 
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
 




 12 Posts in Topic:
Explain explained
markus@[EMAIL PROTECTED]   2008-03-04 09:53:32 
Re: Explain explained
rdeleonp@[EMAIL PROTECTED  2008-03-04 10:21:07 
Re: Explain explained
tgl@[EMAIL PROTECTED] (T  2008-03-04 13:26:17 
Re: Explain explained
markus@[EMAIL PROTECTED]   2008-03-04 15:52:30 
Re: Explain explained
tgl@[EMAIL PROTECTED] (T  2008-03-04 17:30:31 
Re: Explain explained
markus@[EMAIL PROTECTED]   2008-03-04 17:59:45 
numeric definition advice
coder@[EMAIL PROTECTED]   2008-03-07 11:40:55 
Re: numeric definition advice
tgl@[EMAIL PROTECTED] (T  2008-03-07 08:37:30 
Re: numeric definition advice
coder@[EMAIL PROTECTED]   2008-03-07 19:49:04 
warnings restoring a db
coder@[EMAIL PROTECTED]   2008-04-09 08:59:48 
Re: warnings restoring a db
tgl@[EMAIL PROTECTED] (T  2008-04-09 10:43:53 
Re: warnings restoring a db
coder@[EMAIL PROTECTED]   2008-04-09 16:52:00 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Oct 13 2:24:19 CDT 2008.