I’m working through the Hard Upgrade instructions for PostGIS 2.0SVN install instructions. No great surprises, but a succinct set of steps for trying out PostGIS 2.0 early.
In our case, we needed to exclude larger (30GB) tables from the dump needed to do an upgrade– we’ll build those into the new database selectively. Looking to the pg_dump instructions, the dash “T” (-T) flag is what we need. Word to the wise (or note to self, as it were)– explicitly calling out the schema name in the table wildcard helps.
pg_dump -h localhost -p 5432 -U postgres -Fc -b -v -T cool_schma.*contou rs* -f "cool_database.backup" CM