From: | Evan Martin <postgresql(at)realityexists(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Spurious error messages from pg_restore |
Date: | 2013-09-05 09:27:04 |
Message-ID: | 52284E68.4020909@realityexists.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
No version boundaries. I can reproduce this on 9.2.4 by backing up and
immediately restoring a new DB with PostGIS:
CREATE DATABASE test;
CREATE EXTENSION postgis; -- Version 2.1
pg_dump --format custom --file test.bak test
pg_restore --jobs 4 --dbname test test.bak
On 04.09.2013 23:31, David Johnston wrote:
> Evan Martin wrote
>> Also, even without --clean I get 3 errors:
>>
>> pg_restore: [archiver (db)] Error while PROCESSING TOC:
>> pg_restore: [archiver (db)] Error from TOC entry 6755; 2618 4417788 RULE
>> geometry_columns_delete em
>> pg_restore: [archiver (db)] could not execute query: ERROR: rule
>> "geometry_columns_delete" for relation "geometry_columns" already exists
>> Command was: CREATE RULE geometry_columns_delete AS ON DELETE TO
>> geometry_columns DO INSTEAD NOTHING;
>>
>> (and same for "geometry_columns_insert" and "geometry_columns_update")
> I should probably go read up on this but I thought the behavior of
> extensions was such that anything created from an extension is omitted from
> the traditional dump/restore process.
>
> Is this a within 9.2 dump/restore or are you crossing version boundaries
> somewhere?
>
> What was the original version of PostgreSQL when PostGIS was installed and
> how was it installed?
>
> David J.
>
>
>
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/Spurious-error-messages-from-pg-restore-tp5769545p5769626.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | ascot.moss@gmail.com | 2013-09-05 13:19:41 | Question About WAL filename and its time stamp |
Previous Message | Tomas Vondra | 2013-09-05 09:05:48 | Re: Old record migration to another table made the db slower |