If it's more than even like 10GB this is going to take _awhile_.
I love the pg_* commands but they ain't exactly the speediest things around.