pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Backward compatibility psql  8.1 to 8.2
5+ messages / 4 participants
[nested] [flat]

* Backward compatibility psql  8.1 to 8.2
@ 2008-02-12 08:22 Bryce Nesbitt <bryce1@obviously.com>
  2008-02-12 08:32 ` Re: Backward compatibility psql  8.1 to 8.2 Richard Huxton <dev@archonet.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Bryce Nesbitt @ 2008-02-12 08:22 UTC (permalink / raw)
  To: pgsql-sql

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 backslash commands,
  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




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Backward compatibility psql  8.1 to 8.2
  2008-02-12 08:22 Backward compatibility psql  8.1 to 8.2 Bryce Nesbitt <bryce1@obviously.com>
@ 2008-02-12 08:32 ` Richard Huxton <dev@archonet.com>
  2008-02-16 04:32   ` Re: Backward compatibility psql  8.1 to 8.2 Bryce Nesbitt <bryce1@obviously.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Richard Huxton @ 2008-02-12 08:32 UTC (permalink / raw)
  To: Bryce Nesbitt <bryce1@obviously.com>; +Cc: pgsql-sql

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Backward compatibility psql  8.1 to 8.2
  2008-02-12 08:22 Backward compatibility psql  8.1 to 8.2 Bryce Nesbitt <bryce1@obviously.com>
  2008-02-12 08:32 ` Re: Backward compatibility psql  8.1 to 8.2 Richard Huxton <dev@archonet.com>
@ 2008-02-16 04:32   ` Bryce Nesbitt <bryce1@obviously.com>
  2008-02-16 05:22     ` Re: Backward compatibility psql 8.1 to 8.2 Scott Marlowe <scott.marlowe@gmail.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Bryce Nesbitt @ 2008-02-16 04:32 UTC (permalink / raw)
  To: Richard Huxton <dev@archonet.com>; pgsql-sql

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.



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Backward compatibility psql 8.1 to 8.2
  2008-02-12 08:22 Backward compatibility psql  8.1 to 8.2 Bryce Nesbitt <bryce1@obviously.com>
  2008-02-12 08:32 ` Re: Backward compatibility psql  8.1 to 8.2 Richard Huxton <dev@archonet.com>
  2008-02-16 04:32   ` Re: Backward compatibility psql  8.1 to 8.2 Bryce Nesbitt <bryce1@obviously.com>
@ 2008-02-16 05:22     ` Scott Marlowe <scott.marlowe@gmail.com>
  2008-02-17 15:23       ` Re: Backward compatibility psql 8.1 to 8.2 Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 1 reply; 5+ messages in thread

From: Scott Marlowe @ 2008-02-16 05:22 UTC (permalink / raw)
  To: Bryce Nesbitt <bryce1@obviously.com>; +Cc: Richard Huxton <dev@archonet.com>; pgsql-sql

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
>



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Backward compatibility psql 8.1 to 8.2
  2008-02-12 08:22 Backward compatibility psql  8.1 to 8.2 Bryce Nesbitt <bryce1@obviously.com>
  2008-02-12 08:32 ` Re: Backward compatibility psql  8.1 to 8.2 Richard Huxton <dev@archonet.com>
  2008-02-16 04:32   ` Re: Backward compatibility psql  8.1 to 8.2 Bryce Nesbitt <bryce1@obviously.com>
  2008-02-16 05:22     ` Re: Backward compatibility psql 8.1 to 8.2 Scott Marlowe <scott.marlowe@gmail.com>
@ 2008-02-17 15:23       ` Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 0 replies; 5+ messages in thread

From: Peter Eisentraut @ 2008-02-17 15:23 UTC (permalink / raw)
  To: pgsql-sql; +Cc: Scott Marlowe <scott.marlowe@gmail.com>; Bryce Nesbitt <bryce1@obviously.com>; Richard Huxton <dev@archonet.com>

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/



^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2008-02-17 15:23 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-02-12 08:22 Backward compatibility psql  8.1 to 8.2 Bryce Nesbitt <bryce1@obviously.com>
2008-02-12 08:32 ` Richard Huxton <dev@archonet.com>
2008-02-16 04:32   ` Bryce Nesbitt <bryce1@obviously.com>
2008-02-16 05:22     ` Re: Backward compatibility psql 8.1 to 8.2 Scott Marlowe <scott.marlowe@gmail.com>
2008-02-17 15:23       ` Re: Backward compatibility psql 8.1 to 8.2 Peter Eisentraut <peter_e@gmx.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox