Re: Postgres installation issue

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