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@gmail.com> 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
