Thread: Postgres installation issue
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.
--
*Regards,*
*Mirav T. Mehta*
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 > <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/ > <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
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
root@ubuntu:~# *apt-get install postgresql-9.4*
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
libpq5 pgdg-keyring postgresql-client-9.4 postgresql-client-common
postgresql-common postgresql-contrib-9.4 sysstat
Suggested packages:
locales-all postgresql-doc-9.4 libjson-perl libdbd-pg-perl isag
The following NEW packages will be installed:
libpq5 pgdg-keyring postgresql-9.4 postgresql-client-9.4
postgresql-client-common postgresql-common postgresql-contrib-9.4 sysstat
0 upgraded, 8 newly installed, 0 to remove and 327 not upgraded.
Need to get 5,970 kB of archives.
After this operation, 26.8 MB of additional disk space will be used.
Do you want to continue? [Y/n] Y
*Get:1 http://us.archive.ubuntu.com/ubuntu/
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.
>
> --
>
> *Regards,*
> *Mirav T. Mehta*
>
>
>
--
*Regards,*
*Mirav T. Mehta*
*Amrita Center for Wireless Networks and Applications*
*Amrita School of Engineering, Amritapuri Campus.*
*LinkedIn *
Hi Mirav, Am Montag, den 04.12.2017, 17:52 +0530 schrieb Mirav T. Mehta: > Hi > Trying to install postgres 9.4, following are the steps i followed > > 1. wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.a > scsc | sudo apt-key add - > 2. sudo apt-add-repository 'deb http://apt.postgresql.org/pub/repos/a > pt/ trusty-pgdg main' > 3. sudo apt-get update > 4. sudo apt-get install postgresql-9.4 > > root@ubuntu:~# apt-get install postgresql-9.4 > Reading package lists... Done > Building dependency tree > Reading state information... Done > The following extra packages will be installed: > libpq5 pgdg-keyring postgresql-client-9.4 postgresql-client-common > postgresql-common postgresql-contrib-9.4 sysstat > Suggested packages: > locales-all postgresql-doc-9.4 libjson-perl libdbd-pg-perl isag > The following NEW packages will be installed: > libpq5 pgdg-keyring postgresql-9.4 postgresql-client-9.4 > postgresql-client-common postgresql-common postgresql-contrib-9.4 > sysstat > 0 upgraded, 8 newly installed, 0 to remove and 327 not upgraded. > Need to get 5,970 kB of archives. > After this operation, 26.8 MB of additional disk space will be used. > Do you want to continue? [Y/n] Y > Get:1 http://us.archive.ubuntu.com/ubuntu/ trusty/main sysstat amd64 > 10.2.0-1 [283 kB] > Get:2 http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg/main > libpq5 amd64 10.1-1.pgdg14.04+1 [157 kB] > Get:3 http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg/main pgdg- > keyring all 2017.3 [10.3 kB] > Get:4 http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg/main > postgresql-client-common all 188.pgdg14.04+1 [81.5 kB] > Get:5 http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg/main > postgresql-client-9.4 amd64 9.4.15-1.pgdg14.04+1 [1,085 kB] > Get:6 http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg/main > postgresql-common all 188.pgdg14.04+1 [220 kB] > Get:7 http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg/main > postgresql-9.4 amd64 9.4.15-1.pgdg14.04+1 [3,684 kB] > Get:8 http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg/main > postgresql-contrib-9.4 amd64 9.4.15-1.pgdg14.04+1 [449 kB] > Fetched 5,970 kB in 6s (870 kB/s) > > > Why does it fetch 10.X.X ??? > How can I make sure it fetch's 9.4 related files? The main component of the apt.postgresql.org repository always contains the latest stable version of libpq. This is expected behavior and not a problem. See [1] for more information. [1] https://wiki.postgresql.org/wiki/Apt/FAQ#I_want_libpq5_for_version_ X.2C_but_there_is_only_version_Y_in_the_repository Regards, - Adrian