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

2010-12-27 Thread John R Pierce
On 12/27/10 11:44 AM, Tom Lane wrote: Right, but the key word in that sentence is "forwards". Dumping from an 8.3 database with 9.0 pg_dump will likely produce SQL that doesn't reload into an 8.3 server, only into 9.0. heh, thats what I was trying to say, before my first cup of coffee :) sorry

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

2010-12-27 Thread Guillaume Lelarge
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 >>> i

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

2010-12-27 Thread Tom Lane
John R Pierce writes: > On 12/27/10 11:00 AM, Guillaume Lelarge wrote: >> 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.

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

2010-12-27 Thread John R Pierce
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 env

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

2010-12-27 Thread Guillaume Lelarge
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