Обсуждение: Backward compatibility psql 8.1 to 8.2
I'm getting the dreaded psql warning: WARNING: You are connected to a server with major version 8.1, but your psql client is major version 8.2. Some backslashcommands, such as \d, might not work properly. And indeed, most stuff works, but \d for a specific table fails. Has there been talk of making a backwards compatibility nod here? I don't want to downgrade my development machine, and I don't control the remote machine. How fundamentally different is the protocol -- and would it be feasible to support both? -Bryce
Bryce Nesbitt wrote: > And indeed, most stuff works, but \d for a specific table fails. Has > there been talk of making a backwards compatibility nod here? I don't > want to downgrade my development machine, and I don't control the remote > machine. How fundamentally different is the protocol -- and would it be > feasible to support both? Feasible no doubt, but fiddly and useless to most. You can have multiple installations on the same machine. I think most of the developers do as do many of the rest of us. What platform are you running? Debian has built-in support for this, but you can do it yourself for most installations. -- Richard Huxton Archonet Ltd
I'm running SUSE 10.3. I have to install something behind the back of the package manager to keep two versions of psql around. Its not the end of the world, but it's a hassle... and fiddly in it's own right. A 8.2/8.3 client that could talk to 8.1 would save hassle here. Richard Huxton wrote: > Feasible no doubt, but fiddly and useless to most. > > You can have multiple installations on the same machine. I think most > of the developers do as do many of the rest of us. What platform are > you running? Debian has built-in support for this, but you can do it > yourself for most installations.
Up until 8.2 I never used packages because I ran RH or FC and built from source since 6.5.2 or so. I started using packages with ubuntu, and having 8.0, 8.1, and 8.2 installed at the same time, and it's wonderful for troubleshooting issues that might crop up between versions. The Debian / Ubuntu way is really much better than the rpm one. Does anyone who know about packaging know if this a limitation of the packaging spec in rpm, or is there a relatively simple way to get an rpm based machine to run >1 ver of pgsql at a time? On Feb 15, 2008 10:32 PM, Bryce Nesbitt <bryce1@obviously.com> wrote: > I'm running SUSE 10.3. I have to install something behind the back of > the package manager to keep two versions of psql around. Its not the > end of the world, but it's a hassle... and fiddly in it's own right. A > 8.2/8.3 client that could talk to 8.1 would save hassle here. > > Richard Huxton wrote: > > Feasible no doubt, but fiddly and useless to most. > > > > You can have multiple installations on the same machine. I think most > > of the developers do as do many of the rest of us. What platform are > > you running? Debian has built-in support for this, but you can do it > > yourself for most installations. > > ---------------------------(end of broadcast)--------------------------- > TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate >
Scott Marlowe wrote: > Does anyone who know about packaging know if this a limitation of the > packaging spec in rpm, or is there a relatively simple way to get an > rpm based machine to run >1 ver of pgsql at a time? The difference is merely that the packaging doesn't support that setup. -- Peter Eisentraut http://developer.postgresql.org/~petere/