Thanks Leo / Regina. You were right -- I had dumped previously just straight SQL. I've re-dumped and now restoring… Seems to be working.
Thanks too for the --jobs=3 tip! On 2011-11-09, at 3:06 PM, Paragon Corporation wrote: > Rene, > > My guess is you probably did an SQL backup instead of a compressed or tar > backup. > > I've had this issue before when backing up with pgAdmin and the reason is > because it defaults to sql backup I think. I forget what the switch is > you can check our backup /restore cheatsheet for reference. > > http://www.postgresonline.com/downloads/special_feature/postgresql90_pg_dump > restore_cheatsheet.pdf > > (you want -F c -b > > pg_restore can only be used to restore tar or compressed backups. > > We restore the tiger data all the time to various servers so no issue there. > > > Leo and Regina > http://www.postgis.us > > > >> -----Original Message----- >> From: [email protected] >> [mailto:[email protected]] On >> Behalf Of René Fournier >> Sent: Wednesday, November 09, 2011 2:10 PM >> To: PostGIS Users Discussion >> 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 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
