A couple weeks ago, I built an entire geocoder database in PostGIS 1.5.3 using
the impressive Tiger Geocoder 2010 build scripts
(http://svn.osgeo.org/postgis/trunk/extras/tiger_geocoder/tiger_2010/). It took
a couple days, but in the end it worked.
Then I set about moving my work to another server, but to save time I decided
to dump and then restore the database.
dev> pg_dump -U su gc -f gc.sql
prod> psql -U su -d gc -f gc.sql
It didn't work. Well, the file got dumped without errors, etc. But when I tried
restoring (after creating the database gc4 on the new server), Postgresql threw
all kinds of errors.
Anyway, this appears a lot more complex than a basic MySQL database, so I was
wondering how do you guys dump/restore such a database? What's the best
approach? I would tinker with this more, but because the sql file is so big
(~90GB), it's too time consuming to experiment.
Thanks.
…Rene
