[postgis-tickets] [PostGIS] #2223: Rules on geometry_columns make noisy backup/restore

[PostGIS]

#2223: Rules on geometry_columns make noisy backup/restore
-----------------------------------+----------------------------------------
 Reporter:  pramsey                |       Owner:  robe         
     Type:  defect                 |      Status:  new          
 Priority:  medium                 |   Milestone:  PostGIS 2.0.4
Component:  build/upgrade/install  |     Version:  2.0.x        
 Keywords:  rules                  |  
-----------------------------------+----------------------------------------

Comment(by rburhum):

 There are actually two cases:

 1.- {{{ pg_dump -FC }}}  && {{{ pg_restore }}}
 2.- {{{ pg_dump }}} (default) && {{{ psql -f }}}


 Versions of source and destination server:

 In the server (where the pg_dump is generated):

 {{{
 project_5=# select postgis_version();
             postgis_version
 ---------------------------------------
  2.0 USE_GEOS=1 USE_PROJ=1 USE_STATS=1

 /usr/lib/postgresql/9.1/bin/psql --version
 psql (PostgreSQL) 9.1.9
 contains support for command-line editing

 }}}

 In the local machine (where the pg_restore is called)
 {{{
 project_5=# select postgis_version();
             postgis_version
 ---------------------------------------
  2.0 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
 (1 row)


 psql --version
 psql (PostgreSQL) 9.2.4

 }}}

 So it looks like they are the same postgis, but different postgresql.

 For the second case With {{{ pg_dump -FC }}} (the custom postgres format)
 I don't even get the full postgis tables/views back.

 I just switched to using the (default) text-based pg_dump and and pipe to
 psql for the restore (the 1st case). In that scenario, I get the
 tables/views back but the permissions are not maintained.

 If understood you right, it seems that you may have the 2nd case fixed,
 but perhaps the first one is not?

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