Re: waring from pg_restore

you should use the PG 8.1 pg_dump to dump the 7.4.3 database and then import
it into the new server. It is not recommended to do it the way you have
done it.

On 4/25/06, Uwe Maiwald <u(dot)maiwald(at)kiss-net(dot)de> wrote:
>
> Hi,
>
> i get the following warning from pg_restore and would like to know if i
> can
> safely ignore it, or some action should be taken.
>
> pg_restore: creating FUNC PROCEDURAL LANGUAGE plpgsql_call_handler()
> pg_restore: [archiver] WARNING: don't know how to set owner for object
> type
> FUNC PROCEDURAL LANGUAGE
> pg_restore: creating PROCEDURAL LANGUAGE plpgsql
>
> i did the following to produce the warning on linux
>
> From postgresql 7.4.3: pg_dump –Ft –d –b databasename > filename
> In postgresql 8.1.3: pg_restore –Ft –v –d databasename filename
>
> Any ideas why this happens?
>
> Thanks, Uwe
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>