Re: Dumping without Postgis functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tyler Durden <tylersticky(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Dumping without Postgis functions
Date: 2009-10-12 14:08:08
Message-ID: 7233.1255356488@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tyler Durden <tylersticky(at)gmail(dot)com> writes:
> I'm trying to migrate a database from an old posgresql 8.1 server to a
> new one 8.3. I have the Postgis installed on that old database, that
> is not used.
> When I try to restore the database, several errors happens because of
> the various links to libs of Postgis on the disk .

> How do I dump the database without Postgis stuff?

Why don't you just ignore the errors during reload? That seems a lot
less error-prone than trying to excise the stuff from the old DB.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2009-10-12 14:32:06 Re: Ranking search results using multiple fields in PostgreSQL fulltext search
Previous Message Tom Lane 2009-10-12 14:06:33 Re: Where can I get the number of plans that considered by Planner?