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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
