On 9/9/2013 4:53 PM, John R Pierce wrote:
On 9/9/2013 7:00 AM, Chris Curvey wrote:
any idea where I go from here?
don't develop on a newer version of the database than you are deploying on.
*maybe* you can use the pgdump from 8.4 to connect to and dump the 9.2 database, but the 9.2 dump is NOT guaranteed to generate 8.4 compatible SQL, in fact its highly likely it won't, as you can already attest to.
oops, I re-read yur request, you're going the other way.
use the pg_dump from 9.2 to dump the 8.4 database, via either a direct network connection, or an ssh tunnel, or whatever works best. this is guaranteed to work
--
john r pierce 37N 122W
somewhere on the middle of the left coast