Re: Working with v8.3.4 DB using v9.0.1 software

Le 27/12/2010 20:38, John R Pierce a écrit :
> 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 older install
>>> is "frozen" for the project (which is nearing completion) for
>>> environment stability reasons. This is out of my 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.
>

Yeah, you can dump from an old release, but you're not garanteed you'll
be able to restore it on an older release.

> pg_restore, yeah, I would not use pg_restore 9 to restore a dump onto a
> 8.3.x database.
>

--
Guillaume
http://www.postgresql.fr
http://dalibo.com