"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