Re: [GENERAL] error msg when pg_restore

2006-08-23 Thread Tom Lane
"nuno" <[EMAIL PROTECTED]> writes: > pg_restore: [archiver (db)] could not execute query: ERROR: could not > access file "$libdir/dbsize": No such file or directory > Command was: CREATE FUNCTION relation_size(text) RETURNS bigint > AS '$libdir/dbsize', 'relation_size' > LANGUAGE c STR

Re: [GENERAL] error msg when pg_restore

2006-08-23 Thread nuno
by the way, i had 3 different types of errors messages; 1. pg_restore: [archiver (db)] Error from TOC entry 17; 1255 17233 FUNCTION database_size(name)* postgres 2. pg_restore: [archiver (db)] could not execute query: ERROR: could not access file "$libdir/dbsize"**: No such file or directory... 3.

Re: [GENERAL] error msg when pg_restore

2006-08-23 Thread nuno
hi, there, tom. thank you for your help. i turned -c off and now i find a less no. of errors, however, i still get them! (i used to have approx 70 'errors ignored on restore', now i have approx 30 or even less than that). one of errors is like below; pg_restore: [archiver (db)] Error from TOC en

Re: [GENERAL] error msg when pg_restore

2006-08-22 Thread Tom Lane
"nuno" <[EMAIL PROTECTED]> writes: > when i restore a database (using a backup file), it shows me some error > messages which do not seem to matter at all (there is no data lost in > the database, and maybe they're just warning messages...). > pg_restore: [archiver (db)] could not execute query: E

[GENERAL] error msg when pg_restore

2006-08-22 Thread nuno
good'ay everyone. i have this problem which may not be a big deal, however, it'd be great if you could help me if possible. when i restore a database (using a backup file), it shows me some error messages which do not seem to matter at all (there is no data lost in the database, and maybe they're