[postgis-users] Problems with backing up and restoring Tiger Geocoder database

[Greg Williamson]

Perhaps more information on the specific pg_dump / pg_restore commands used, and some information on the servers would be useful ?

Greg Williamson


----- Original Message -----
> From: René Fournier <m5 at renefournier.com>
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Cc: 
> Sent: Wednesday, November 9, 2011 11:10 AM
> Subject: [postgis-users] Problems with backing up and restoring Tiger Geocoder database
> 
> Since building the Tiger Geocoder database from the source data is so 
> time-consuming, I'm trying to capture the result (the ~90GB spatially aware 
> database) so that I can simply restore, in case I need to rebuild the server. 
> Should be simple, but every time I pg_dump and attempt to pg_restore, I get
> 
>     pg_restore: [archiver] input file does not appear to be a valid archive
> 
> So, just wondering what I'm doing wrong? Or, put another way, what are the 
> steps to dump the given database and restore it to another server running 
> Postgresql90 and PostGIS 1.5.3? Thanks!
> 
> …Rene
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>