On 12/27/10 11:00 AM, Guillaume Lelarge wrote:
> Le 27/12/2010 18:27, Gauthier, Dave a écrit :
>> Hi:
>>
>> I'm working with 2 different PG installs on 2 different linux servers, one running v9.0.1 and the other v8.3.4. The
olderinstall is "frozen" for the project (which is nearing completion) for environment stability reasons. This is out
ofmy control. I cannot upgrade v8.3.4 on that server. But I would like to be able to use psql v9.0.1 on the older DB.
It seems to work, with a warning that some features may not be available or work right.
>>
>> My question has to do with backward compatibility, v9.0.1 and v8.3.4. Can I use v9.0.1 software (psql, pg_ctl,
etc...)on the v8.3.4 DB with confidence?
>>
> psql should work the same, apart from new metacommands. I don't think
> you'll experience issues with pg_ctl. I would not recommend you to user
> pg_dump and pg_restore. They are pretty sensitive to the PostgreSQL release.
pg_dump is designed specifically to be able to dump from all supported
older versions so you can convert the data forwards.
pg_restore, yeah, I would not use pg_restore 9 to restore a dump onto a
8.3.x database.