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

[René Fournier]

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: postgis-users-bounces at postgis.refractions.net 
>> [mailto:postgis-users-bounces at postgis.refractions.net] 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
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users