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.
pg_restore, yeah, I would not use pg_restore 9 to restore a dump onto a
8.3.x database.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
