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 <[email protected]> > To: PostGIS Users Discussion <[email protected]> > 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 > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
