Re: incorrect restore from pg_dumpall

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 your old database.

You can hack around this, and have your cake and eat it too, to an
extent, by symlinking the name of your old postgis to your new postgis
library.

P

On Fri, Nov 27, 2009 at 4:11 PM, Tomas Lanczos <lanczos(at)t-zones(dot)sk> wrote:
> Hello,
>
> I am trying to restore my databases stored by a pg_dumpall command in
> the Karmic Koala box. The restore command is the following:
>
> psql -f /media/disk/.../backup -U postgres
>
> I have a PostsgreSQL 8.4 installed from repositories with postgis1.4.1.
> I recognized that the tables with spatial geometries were not restored
> but at the moment I am almost sure  that it's caused by that the older
> version of postgis in the stored database. What is a kind of mystery for
> me that data in several tables were not restored, although the table
> definitions did (it means that I got several tables without data)
> althoug the data are there in the backup file (I checked physically). I
> really don't understand what's going on there, I did the same many times
> before, without any problem.
>
> Tomas
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>