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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general