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. pg_restore: [archiver (db)] could not execute query: ERROR: function public.database_size(name)*** does not exist... * or pg_database_size(oid), pg_dir_ls(text, boolean), pg_file_read(text, bigint, bigint), pg_file_stat(text), etc. ** or "$libdir/admin" *** or public.pg_database_size(oid), public.pg_dir_ls(text, boolean), etc. every single message is one of the types specified above. i read the posts about pg_restore, and i still haven't been able to figure it out. any clue anyone? nuno wrote: > 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 entry 18; 1255 17234 > FUNCTION relatio > n_size(text) postgres > pg_restore: [archiver (db)] could not execute query: ERROR: could not > access fi > le "$libdir/dbsize": No such file or directory > Command was: CREATE FUNCTION relation_size(text) RETURNS bigint > AS '$libdir/dbsize', 'relation_size' > LANGUAGE c STRICT; > > the options i am currently using are -i (ignore-version), -h (host), -d > (database), -U (user) and -W (password). > > is there any way you can fix this problem? > > thanks, nuno > > Tom Lane wrote: > > "nuno" <wegein@xxxxxxxxx> 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: ERROR: function > > > public.plp > > > gsql_validator(oid) does not exist > > > Command was: DROP FUNCTION public.plpgsql_validator(oid); > > > > Apparently you're using the -c option when there's not really anything > > that needs dropping. -c is for removing existing copies of the database > > objects you're restoring. > > > > regards, tom lane > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 2: Don't 'kill -9' the postmaster
