Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Zpfzh-0000M7-6J for pgsql-docs@arkaria.postgresql.org; Fri, 23 Oct 2015 17:19:09 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1Zpfzf-0006il-M6 for pgsql-docs@arkaria.postgresql.org; Fri, 23 Oct 2015 17:19:07 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZpfzJ-0006Lc-P9 for pgsql-docs@postgresql.org; Fri, 23 Oct 2015 17:18:45 +0000 Received: from mail-pa0-x236.google.com ([2607:f8b0:400e:c03::236]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZpfzG-0006mz-OL for pgsql-docs@postgresql.org; Fri, 23 Oct 2015 17:18:44 +0000 Received: by pasz6 with SMTP id z6so123332528pas.2 for ; Fri, 23 Oct 2015 10:18:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=subject:to:references:cc:from:message-id:date:user-agent :mime-version:in-reply-to:content-type; bh=wSHaYy9qNLatNd58F7Nh/FaFgX08FEpflhsS2hfcHLU=; b=CAfPofHroyAW/qYew3han/11RGlQiHKLzsz9OPYBcL/lDqdPd4JKltA/F4bJ5bgaF8 4nh/y5X7vEIX84VQjJpWpllVzIXC5rcJwMWA5oXD0sL+VOhdyx+aIyA8WVjXJDtACY4X hIJ5Bkni85d2RdH7TOU7ua5WIhi2K3aZSz17+XtPJYsS7gPFeM+mYsbhV5PVD6mzqhgP tCyrBGsvpTUKejDsqHWOfvZeRJ+nKhNDf9rsf6yKBUboumQ5++ZEYz/mn78TIdW5k3Vp OII/0tFifCE6M1wnTFF2X1vkSrLJk2Lsw5V6ieEsnQzIwtOg7GPpgTPmZEEpVYch+GPc USNQ== X-Received: by 10.68.179.228 with SMTP id dj4mr6296704pbc.112.1445620721203; Fri, 23 Oct 2015 10:18:41 -0700 (PDT) Received: from [10.55.3.8] ([155.100.233.210]) by smtp.googlemail.com with ESMTPSA id vl1sm19982531pbc.31.2015.10.23.10.18.40 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 23 Oct 2015 10:18:40 -0700 (PDT) Subject: Re: ubuntu deb packaging To: Magnus Hagander References: Cc: "pgsql-docs@postgresql.org" From: Rob Sargent Message-ID: <562A6BEF.6020905@gmail.com> Date: Fri, 23 Oct 2015 11:18:39 -0600 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.2.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------030606010801050304060802" X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org This is a multi-part message in MIME format. --------------030606010801050304060802 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit On 10/23/2015 10:36 AM, Magnus Hagander wrote: > > > On Thu, Oct 22, 2015 at 1:34 AM, Rob Sargent > wrote: > > 1. I have a shiny new desktop running > cat /etc/os-release > NAME="Ubuntu" > VERSION="14.04.3 LTS, Trusty Tahr" > ID=ubuntu > ID_LIKE=debian > PRETTY_NAME="Ubuntu 14.04.3 LTS" > VERSION_ID="14.04" > HOME_URL="http://www.ubuntu.com/" > SUPPORT_URL="http://help.ubuntu.com/" > BUG_REPORT_URL="http://bugs.launchpad.net/ubuntu/" > > 2. Unfortunately I thought it was 14.10 and first put "utopic" in > the list file but that didn't work. big surpries. > 3. But now > cat /etc/apt/sources.list.d/pgdg.list > deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main > > 4.. and after running sudo apt-get update I do indeed get psql. > But is this to be expected? > psql --version > psql (Postgres-XC) 1.1 > (based on PostgreSQL) 9.2.4 > > Dis (mis)step 2 do me in? Should I not see psql version closer to > 9.4? > > > > You seem to have installed psql from Postgres XC rather than from > PostgreSQL. Look if you have any of the XC packages installed and then > remove those, replacing them with the PostgreSQL ones. > > > > -- > Magnus Hagander > Me: http://www.hagander.net/ > Work: http://www.redpill-linpro.com/ Thanks Magnus, removed the xc package, loaded synaptic and got pg9.4. --------------030606010801050304060802 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit
On 10/23/2015 10:36 AM, Magnus Hagander wrote:


On Thu, Oct 22, 2015 at 1:34 AM, Rob Sargent <robjsargent@gmail.com> wrote:
1. I have a shiny new desktop running
cat /etc/os-release
NAME="Ubuntu"
VERSION="14.04.3 LTS, Trusty Tahr"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 14.04.3 LTS"
VERSION_ID="14.04"
HOME_URL="http://www.ubuntu.com/"
SUPPORT_URL="http://help.ubuntu.com/"
BUG_REPORT_URL="http://bugs.launchpad.net/ubuntu/"

2. Unfortunately I thought it was 14.10 and first put "utopic" in the list file but that didn't work.  big surpries. 
3. But now
cat /etc/apt/sources.list.d/pgdg.list
deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main

4.. and after running sudo apt-get update I do indeed get psql. But is this to be expected?
psql --version
psql (Postgres-XC) 1.1
(based on PostgreSQL) 9.2.4

Dis (mis)step 2 do me in?  Should I not see psql version closer to 9.4?



You seem to have installed psql from Postgres XC rather than from PostgreSQL. Look if you have any of the XC packages installed and then remove those, replacing them with the PostgreSQL ones. 



--
Thanks Magnus,

removed the xc package, loaded synaptic and got pg9.4.


--------------030606010801050304060802--