[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:13:23 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):

 Strange I was sure I marked spatial_ref_sys as editable which means the
 structure doesn't get backed up but the data should. But I see what you
 mean individual backup of the table doesn't seem to do anything so maybe
 the include that does this is not being included.

 {{{
 SELECT pg_catalog.pg_extension_config_dump('spatial_ref_sys', '');
 }}}

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