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