Search Postgresql Archives

Re: error msg when pg_restore

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux