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.
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?