Re: pgdump (9.2.4) not dumping all tables

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Marcos Cano *EXTERN*" <mcano(at)stsa(dot)info>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pgdump (9.2.4) not dumping all tables
Date: 2014-11-21 09:05:01
Message-ID: A737B7A37273E048B164557ADEF4A58B17DA3887@ntex2010a.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marcos Cano wrote:
[missing data after dump/restore of DB with PostGIS]
> i found this in the file...
>
> ERROR: could not access file "$libdir/rtpostgis-2.0": No such file or
> directory

Could it be that PostGIS was not installed as an extension in the old database,
so that the dump contains the individual CREATE FUNCTION statements rather than
on "CREATE EXTENSION postgis"?

Yours,
Laurenz Albe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2014-11-21 09:16:40 Re: Performance question
Previous Message Marcos Cano 2014-11-21 05:10:46 Re: pgdump (9.2.4) not dumping all tables