Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id CA1506502E4 for ; Thu, 24 Jul 2008 17:13:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 41303-06 for ; Thu, 24 Jul 2008 17:13:24 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from qb-out-0506.google.com (qb-out-0506.google.com [72.14.204.227]) by postgresql.org (Postfix) with ESMTP id 970406502AA for ; Thu, 24 Jul 2008 17:13:26 -0300 (ADT) Received: by qb-out-0506.google.com with SMTP id d8so4558445qbc.23 for ; Thu, 24 Jul 2008 13:13:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=yIYQBnlXm4cE+9pL6JhMJIjUanvi6r2iYzwgXVgqCyU=; b=KQmQ5NGHHmptGkmG4y0J87TB3LcTLUmBn3O3NJt/ZbEBXcZTeQXvwaJalYdlmvEOY5 Z67I90sQrYEQhs0JEMLwaIsvrYlKPHn5rVpfzzeMPNRy5MYDAMklByT6/I+eTRET52Z0 RrSUtykgdme6MQNQ/Q+Wx2XKMpX3aQHpxWZ/w= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=N+bhrTAFXl6hVA1sYZXRFQ/ZoSbkfGWlEhKQ8tznZ1/OseHdli6Mi7qNMje3ogNJsE LJ8v46ZuQ4VGuXPyBRXkqaNbood5xONeAYY4Uj428OHboAB+1DjrMiDdRfRn9bnyx32E UTzCPetWhVK06g3z4v8r9tJbwc4dBECzg98PY= Received: by 10.142.218.6 with SMTP id q6mr250986wfg.19.1216930404098; Thu, 24 Jul 2008 13:13:24 -0700 (PDT) Received: by 10.142.158.14 with HTTP; Thu, 24 Jul 2008 13:13:24 -0700 (PDT) Message-ID: Date: Thu, 24 Jul 2008 14:13:24 -0600 From: "Scott Marlowe" To: "Chris Bovitz" Subject: Re: Upgrade clients when (major) upgrading server? Cc: pgsql-admin@postgresql.org In-Reply-To: <4888DD27.6070204@noaa.gov> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <488898F0.6010406@noaa.gov> <4888DD27.6070204@noaa.gov> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200807/212 X-Sequence-Number: 29822 On Thu, Jul 24, 2008 at 1:51 PM, Chris Bovitz wrote: > > > Does it matter which version - 8.3.3 or 8.2.9 - we install on our client > boxes? Is the client-side backwards compatible? Or should we install both > and have a wrapper for the "psql" script to detect which database we're > going to and use the appropriate binaries? psql itself is not backwards / forwards compatible. libpq is. So if you need to talk to 8.2 and 8.3 databases from psql, then it's a good idea to have both.