Re: [GENERAL] incorrect restore from pg_dumpall

2009-11-28 Thread Tomas Lanczos
Yes, You were right, the problem was in the different libraries. I worked around by installing the postgis version 1.3.6, reloading the databases and subsequently uprading the postgis to 1.4.1. Thank You for Your help Tomas p.s.: what is really a mystery that also the mentioned table with no dat

Re: [GENERAL] incorrect restore from pg_dumpall

2009-11-27 Thread Paul Ramsey
In order to restore a backup taken with pg_dumpall you'll want to ensure that the postgis installed in your new system is identical to the postgis in your old one. This is because the postgis function definitions will be looking for a particular postgis library name... the name of the library from