Pg-Logical output pkg; can't install 9.4 and 9.5 on same Wheezy box

From: Jerry Sievers <gsievers19(at)comcast(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Pg-Logical output pkg; can't install 9.4 and 9.5 on same Wheezy box
Date: 2016-03-23 22:09:54
Message-ID: 86r3et19t9.fsf@jerry.enova.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hackers, please see below.

Posted on Admin and then General but not sure anyone of authority has noticed.

Briefly, conflicting files in an include directory prevent 9.4/9.5
installed on same host instance. Thanks

-----

Posted to Admin a few days ago... I'll try here next before going to
Hackers or trying to locate the packagers.

----

Anyone else as enthused as I am about Pg-Logical and tried installing
both version on same host?

Fails on the output plugin package due to header file conflict.

I recall as might be expected that the reverse is true also. If you
wipe 9.5 and then install 9.4 it works then you get borked trying to
install the 9.5 version.

I wonder if those headers should be packaged down into a version
numbered directory?

# uname -a
Linux jerry 3.2.0-4-amd64 #1 SMP Debian 3.2.51-1 x86_64 GNU/Linux

#
# echo $#; echo $*
4
postgresql-9.4-pglogical postgresql-9.4-pglogical-output postgresql-9.5-pglogical postgresql-9.5-pglogical-output

# dpkg -l | grep pglogical
ii postgresql-9.5-pglogical 1.0.1-1wheezy amd64 PGLogical plugin for PostgreSQL 9.5
ii postgresql-9.5-pglogical-output 1.0.1-1wheezy amd64 PGLogical Output plugin for PostgreSQL 9.5

# apt-get install -y $1
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
postgresql-9.4-pglogical-output
The following NEW packages will be installed:
postgresql-9.4-pglogical postgresql-9.4-pglogical-output
0 upgraded, 2 newly installed, 0 to remove and 308 not upgraded.
Need to get 0 B/249 kB of archives.
After this operation, 827 kB of additional disk space will be used.
debconf: unable to initialize frontend: Dialog
debconf: (Dialog frontend will not work on a dumb terminal, an emacs shell buffer, or without a controlling terminal.)
debconf: falling back to frontend: Readline
(Reading database ... 173140 files and directories currently installed.)
Unpacking postgresql-9.4-pglogical-output (from .../postgresql-9.4-pglogical-output_1.0.1-1wheezy_amd64.deb) ...
dpkg: error processing /var/cache/apt/archives/postgresql-9.4-pglogical-output_1.0.1-1wheezy_amd64.deb (--unpack):

trying to overwrite '/usr/include/postgresql/pglogical_output/compat.h', which is also in package postgresql-9.5-pglogical-output 1.0.1-1wheezy
^^^^^^^^^^^^^^^^

Selecting previously unselected package postgresql-9.4-pglogical.
Unpacking postgresql-9.4-pglogical (from .../postgresql-9.4-pglogical_1.0.1-1wheezy_amd64.deb) ...
Processing triggers for postgresql-common ...
debconf: unable to initialize frontend: Dialog
debconf: (Dialog frontend will not work on a dumb terminal, an emacs shell buffer, or without a controlling terminal.)
debconf: falling back to frontend: Readline
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
en_us
Removing obsolete dictionary files:
Errors were encountered while processing:
/var/cache/apt/archives/postgresql-9.4-pglogical-output_1.0.1-1wheezy_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

# dpkg -L $4
/.
/usr
/usr/share
/usr/share/postgresql
/usr/share/postgresql/9.5
/usr/share/postgresql/9.5/extension
/usr/share/postgresql/9.5/extension/pglogical_output--1.0.0.sql
/usr/share/postgresql/9.5/extension/pglogical_output--1.0.1.sql
/usr/share/postgresql/9.5/extension/pglogical_output--1.0.0--1.0.1.sql
/usr/share/postgresql/9.5/extension/pglogical_output.control
/usr/share/doc
/usr/share/doc/postgresql-9.5-pglogical-output
/usr/share/doc/postgresql-9.5-pglogical-output/copyright
/usr/share/doc/postgresql-9.5-pglogical-output/changelog.Debian.gz
/usr/share/doc/postgresql-9.5-pglogical-output/README.md.gz
/usr/lib
/usr/lib/postgresql
/usr/lib/postgresql/9.5
/usr/lib/postgresql/9.5/lib
/usr/lib/postgresql/9.5/lib/pglogical_output.so
/usr/include
/usr/include/postgresql
/usr/include/postgresql/pglogical_output

/usr/include/postgresql/pglogical_output/compat.h
^^^^^^^^^^^^^^^^^^

/usr/include/postgresql/pglogical_output/hooks.h

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres(dot)consulting(at)comcast(dot)net
p: 312.241.7800

Browse pgsql-hackers by date

  From Date Subject
Next Message Gilles Darold 2016-03-23 22:22:26 Re: Patch to implement pg_current_logfile() function
Previous Message Peter Geoghegan 2016-03-23 22:08:05 Re: Missing rows with index scan when collation is not "C" (PostgreSQL 9.5)