Hi, I'm encountering some problems with postgis_restore.pl First, it's not easy to get the script to do what i want to: i won't take a username and it will create a database at the specified port (-p 5433), but then it will try to create plpgsql on the 5432 cluster. That is something that should be improved, but it's not my real problem.
The script stops at SELECT postgis_lib_version() with an ERROR and disregards all statements thereafter. The ERROR is caused by the fact that postgis_lib_version() does not exist in the newly created database yet. That is correct, because the script tries to create that function a few queries later! It must work in some other cases, or it should have been noticed by now, but i don's see how. That is probably because i am learning what this script does exactly. There is the complicating factor that the dumpfile is from a linux system, so it might point to the wrong location for the library file. Maybe tthe creation of the script was attempted in vain (because of the path), of which there is no mention. Can somebody please help? I hope to be migrationg a lot both ways soon. (linux to windows and windows to linux) Thanks, -- "Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
