Thread: Two different (postgresql & postgresql93) packages installed?

On 11/06/2015 05:24 PM, Michael Convey wrote:
> Below is from my OpenSUSE command line. I only installed the first
> package, but both say, "Installed: Yes". Why is this? Are they really
> the same package?
>
>
> linux-srqm:~ # zypper info postgresql
> Loading repository data...
> Reading installed packages...
>
>
> Information for package postgresql:
> -----------------------------------
> Repository: openSUSE-13.2-Oss
> Name: postgresql
> Version: 9.3-3.1.2
> Arch: noarch
> Vendor: openSUSE
> Installed: Yes
> Status: up-to-date
> Installed Size: 83 B
> Summary: Basic Clients and Utilities for PostgreSQL
> Description:
>    PostgreSQL is an advanced object-relational database management system
>    that supports an extended subset of the SQL standard, including
>    transactions, foreign keys, subqueries, triggers, and user-defined
>    types and functions.
>    This package contains the basic utility and client programs necessary
>    to maintain and work with local or remote PostgreSQL databases as well
>    as manual pages for the SQL commands that PostgreSQL supports. Full
>    HTML documentation for PostgreSQL can be found in the postgresql-docs
>    package.
> linux-srqm:~ # zypper info postgresql93
> Loading repository data...
> Reading installed packages...
>
>
> Information for package postgresql93:
> -------------------------------------
> Repository: openSUSE-13.2-Update
> Name: postgresql93
> Version: 9.3.10-2.7.1
> Arch: i586
> Vendor: openSUSE
> Installed: Yes
> Status: out-of-date (version 9.3.6-2.4.1 installed)
> Installed Size: 3.9 MiB
> Summary: Basic Clients and Utilities for PostgreSQL
> Description:
>    PostgreSQL is an advanced object-relational database management system
>    that supports an extended subset of the SQL standard, including
>    transactions, foreign keys, subqueries, triggers, and user-defined
>    types and functions.
>    This package contains the basic utility and client programs necessary
>    to maintain and work with local or remote PostgreSQL databases as well
>    as manual pages for the SQL commands that PostgreSQL supports. Full
>    HTML documentation for PostgreSQL can be found in the postgresql-docs
>    package.
> linux-srqm:~ #

The machine I am writing from is openSUSE 13.2, but I install Postgres
from source, so I have not actually used the repo versions. That being
said, what I see is they are coming from different repos, the first from
openSUSE-13.2-Oss and the second from openSUSE-13.2-Update. Also look at
the installed sizes for the first 83 B and 3.9 MiB for the second. I
would say the first is just the placeholder package and the second is
the package that represents the most recent version of that placeholder.

What do you see in psql when you do select version()

--
Adrian Klaver
adrian.klaver@aklaver.com