Ticket #1815 (closed defect: fixed)
spatial_ref_sys table cannot be dumped using pg_dump when installed as an extension
|Reported by:||chander||Owned by:||robe|
The current packaging of PostGIS's spatial_ref_sys table means that it's not dump-able using the pg_dump tool.
This means that a full backup of a database does not include dumps of the spatial_ref_sys table when made by standard postgresql backup tools.
Furthermore, even specifying the table name exactly doesn't cause it to get dumped.
Ref this email from Tom Lane re this issue:
Seems like this is a high priority issue - anyone backing up a PostGIS 2.0 install using the standard PostgreSQL dump tools will not retain in their backups any local changes to the spatial_ref_sys table, which may render a restore unusable for certain types of queries (without adding these back in.)