[postgis-users] problems with postgis_restore.pl

[Willy-Bas Loos]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081106/20206d2e/attachment.html>