Smathermather's Weblog

Remote Sensing, GIS, Ecology, and Oddball Techniques

PostgreSQL dump for PostGIS upgrade

Posted by smathermather on October 27, 2011

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: