Errors on pg_restore

[iriswind]

I have a postgresql cluster with installed extension postgis2 and everyday i run pg_dump for some database: pg_dump -h 127.0.0.1 -p 5432 -d maindb -U postgres -Fc -Z 6 -f /dump/out.sql After that i start restore of my database on test cluster:

pg_restore -h 127.0.0.1 -p 5433 -d maindb_test -Fc -U postgres /dump/out.sql

and i get errors in pg_logs:

pg_restore: [archiver (db)] Error from TOC entry 6932; 2753 17959 OPERATOR FAMILY btree_geography_ops postgres pg_restore: [archiver (db)] could not execute query: ERROR: operator family "btree_geography_ops" for access method "btree" already exists

Command was: CREATE OPERATOR FAMILY btree_geography_ops USING btree;

Can you help me to solve the problem?

Postgresql details: "PostgreSQL 9.3.5 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit POSTGIS="2.1.5 r13152" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.7.6" LIBJSON= (…)".

With regards, Pantileenko Denis system administrator LLC "Techniology" irisregit@…

[robe]

Hmm I feel this question would be better asked on our user group mailing list, as I suspect this is not a bug but just something specific oabout how you are set up.

For example if your database you are restoring into has already got PostGIS installed, you'll get this error and you can safely ignore it.

If you installed PostGIS with extension support and are restoring a backup not installed with PostGIS extensions, you'll get this error too.

Anyway I'm going to close this out and refer you to our mailing list for help. ​http://lists.osgeo.org/mailman/listinfo/postgis-users

This bug tracker is only for what we deem bugs and not for user specific issues.