[postgis-tickets] [PostGIS] #3035: Errors on pg_restore

[PostGIS]

#3035: Errors on pg_restore
----------------------+-----------------------------------------------------
 Reporter:  iriswind  |       Owner:  pramsey
     Type:  defect    |      Status:  new    
 Priority:  medium    |   Milestone:         
Component:  postgis   |     Version:  2.1.x  
 Keywords:            |  
----------------------+-----------------------------------------------------
 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 at yahoo.com

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/3035>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.