On Wed, Feb 16, 2005 at 06:16:36PM -0700, Pritesh Shah wrote:
> hi,
>
> I would like to thank everybody for their responses to my question. I
> tried a couple of things and the best thing for me was to use
> utils/postgis_restore.pl script.
>
> I ran this script on some sample databases and they
Hi, Pitesh,
[EMAIL PROTECTED] schrieb:
> You can't simply restore a dump to upgrade postgis
> for two reasons:
>
> 1) postgis library name might have changed (this is the case).
> 2) postgis procedural language function might be changed
> and you'd get the old ones.
>
> You
You can't simply restore a dump to upgrade postgis
for two reasons:
1) postgis library name might have changed (this is the case).
2) postgis procedural language function might be changed
and you'd get the old ones.
You can find an utility script in the utils/ directory
The short answer is that you leave out all the postgis function calls in
your dump, create a new database and load the postgis functions using the
new scripts. Then you just load the data.
I didn't find an easy way to selectively load tables and views using the
.sql format (and I actually didn't