Postgres Pro
Downloads
Home   >   mailing lists

Thread: waring from pg_restore

waring from pg_restore

From
Uwe Maiwald
Date:
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

Re: waring from pg_restore

From
"Chris Hoover"
Date:
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.maiwald@kiss-net.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