Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eKm7g-0002u5-NZ for pgsql-bugs@arkaria.postgresql.org; Fri, 01 Dec 2017 14:17:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eKm7f-0008Dz-UT for pgsql-bugs@arkaria.postgresql.org; Fri, 01 Dec 2017 14:16:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eKm7f-0008Dp-Oh for pgsql-bugs@lists.postgresql.org; Fri, 01 Dec 2017 14:16:59 +0000 Received: from mail-wr0-x230.google.com ([2a00:1450:400c:c0c::230]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1eKm7b-0006d3-KF for pgsql-bugs@postgresql.org; Fri, 01 Dec 2017 14:16:58 +0000 Received: by mail-wr0-x230.google.com with SMTP id o2so10261619wro.5 for ; Fri, 01 Dec 2017 06:16:54 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-language:content-transfer-encoding; bh=32RsA1g0KcsUl9AbtKdqTCmObpwwFLDmwOyW45MJMKQ=; b=x/bpLFt3FMkKguRSA1ehQvNqGmYG6AvYtOojapAPCmKE2wa+Y9DorVtf2rqTW+3RKV fcWcuBhhukYTplrj9b3pBigbiY3Wp/QAWjL1HTohsTvOAbrcvY9AIYBGmBcfeuI96BKh 7ZzFD92EgM1O+NfWKLW5oDaLyRpTsWVQE+7hVrj24GFKN5Dg5PTT+LVT3UceSiA11Phc GDv2ZtXaAPLJWHgOiEThmodnOQkx/oh9as7qlBS4oRspjJhaK+i5bwCBDMQy2R1zFt8l 2hnGGIAFXdrTNtvvTP1G+z5PzWTO2FYS8q8mZDp5ESbxZNhIwk/oly/JwWUqyZp7wqo5 dcEA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=32RsA1g0KcsUl9AbtKdqTCmObpwwFLDmwOyW45MJMKQ=; b=ddQNDQWPH97iPqDMHja8uspNs5pHB2YxdL1f9mqPD3yQ0b3eu+xXlS6O9HR+ndnTsL pleu1/gArnJxTIvxIy3puYwonshjSJ/WDrJTyQHrRi4HNGH9pmms9qaUpo74eZjb2O+U ktBJRXiVmnFxHF1E+l8RXj4Dn3kdYx3us/d7WpndQAdw2mlgdqpp4w/VLMPFcr4sDo9P LcamhyTSrjOxuvqtAjYm4psOuxpEX/7fRY+JBRk7bNk/fBwSiCjtPbyAVf6W6wZ61taF INNTjxBwk/oCWrVZ7Aj0zZKhk31pMnQeG3lLLFxFHpKRYDVeeenV5V8ZIXLsbqq1RbRW 2kIw== X-Gm-Message-State: AJaThX5wP+dZEyaqUes+wlK1hjNdvoIbGZ9Znc8hYr2hS1n4MlGqwthy PUyD2ukr7oiD8okyCbgvW3ax8g== X-Google-Smtp-Source: AGs4zMZ6q2is5e6vw0IUGc3DoG9Sa3qpZwCAQI6u+k06fEcy+TO3inX0C+u9c6J3Xx+/5oOCFBtKBQ== X-Received: by 10.223.160.184 with SMTP id m53mr5449704wrm.126.1512137813581; Fri, 01 Dec 2017 06:16:53 -0800 (PST) Received: from [10.137.2.19] (ip-78-102-97-226.net.upcbroadband.cz. [78.102.97.226]) by smtp.gmail.com with ESMTPSA id k2sm4669458wrg.4.2017.12.01.06.16.50 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 01 Dec 2017 06:16:51 -0800 (PST) Subject: Re: Postgres installation issue To: "Mirav T. Mehta" , pgsql-bugs@postgresql.org Cc: vinanv@gmail.com References: From: Tomas Vondra Message-ID: Date: Fri, 1 Dec 2017 15:16:49 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.3.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 12/01/2017 02:22 PM, Mirav T. Mehta wrote: > Hi  > Trying to install postgres 9.4, following are the steps i followed  > > 1. wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc > | sudo apt-key add - > 2. sudo apt-add-repository 'deb http://apt.postgresql.org/pub/repos/apt/ > trusty-pgdg main' > 3. sudo apt-get update > 4. sudo apt-get install postgresql-9.4 > > > At the end of installation when I check pg_config file, I am observing > version as 10.1. > ____________ > Collecting psycopg2==2.6.1 (from -r > /opt/aruba/gmaster/lib/zeus/requirements.txt (line 12)) >   Using cached psycopg2-2.6.1.tar.gz >     Complete output from command python setup.py egg_info: >     running egg_info >     creating pip-egg-info/psycopg2.egg-info >     writing pip-egg-info/psycopg2.egg-info/PKG-INFO >     writing top-level names to pip-egg-info/psycopg2.egg-info/top_level.txt >     writing dependency_links to > pip-egg-info/psycopg2.egg-info/dependency_links.txt >     writing manifest file 'pip-egg-info/psycopg2.egg-info/SOURCES.txt' >     Error: could not determine PostgreSQL version from '10.1' >      >     ---------------------------------------- > Command "python setup.py egg_info" failed with error code 1 in > /tmp/pip-build-_zIza9/psycopg2/ > _______________ > > > Because of this My psycopg2 2.6.1 is failing. as Postgres version > indicated is 10.1. > > I am working on a legacy code build on top of postgresql-9.4 and > psycopg2 version 2.6.1 > > Please let me know in case steps followed needs to be corrected. > Install a new psycopg2 version, supporting PostgreSQL 10. The version number format changes in PostgreSQL 10, and psycopg2 2.6.1 is unable to parse it. FWIW this is not a PostgreSQL issue, it's more about psycopg2. So perhaps ask in psycopg2 mailing list instead: https://www.postgresql.org/list/psycopg/ regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services