[postgis-devel] [PostGIS] #1815: spatial_ref_sys table cannot be dumped using pg_dump when installed as an extension

PostGIS trac at osgeo.org
Tue May 15 05:20:31 PDT 2012


#1815: spatial_ref_sys table cannot be dumped using pg_dump when installed as an
extension
---------------------+------------------------------------------------------
 Reporter:  chander  |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  high     |   Milestone:  PostGIS 2.0.1
Component:  postgis  |     Version:  2.0.x        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by robe):

 Okay I just did a full backup of my database and it includes the data of
 spatial_ref_sys (but not the structure), as I would expect it to.  So full
 backup seems fine.

 However if I try to just backup spatial_ref_sys or even public schema, I
 get nothing.

 I suspect this may be a bug in the PostgreSQL extension model unless I am
 missing something.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1815#comment:2>
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.


More information about the postgis-devel mailing list