Thread: cannot install postgis30 / rhel7
$ sudo http_proxy=http://localhost:8888 yum -y install -- postgis30_11{,-client} ... Resolving Dependencies --> Running transaction check ---> Package postgis30_11.x86_64 0:3.0.0alpha4-2.rhel7 will be installed --> Processing Dependency: proj61 for package: postgis30_11-3.0.0alpha4-2.rhel7.x86_64 --> Processing Dependency: libproj.so.15()(64bit) for package: postgis30_11-3.0.0alpha4-2.rhel7.x86_64 ---> Package postgis30_11-client.x86_64 0:3.0.0alpha4-2.rhel7 will be installed --> Running transaction check ---> Package proj61.x86_64 0:6.1.0-1.rhel7 will be installed --> Processing Dependency: sqlite-libs >= 3.7 for package: proj61-6.1.0-1.rhel7.x86_64 --> Finished Dependency Resolution Error: Package: proj61-6.1.0-1.rhel7.x86_64 (pgdg10) Requires: sqlite-libs >= 3.7 You could try using --skip-broken to work around the problem You could try running: rpm -Va --nofiles --nodigest It seems to me the build machines should verify ability install the packages, perhaps in a chroot or similar. Justin
Hi, On Fri, 2019-09-13 at 16:39 -0500, Justin Pryzby wrote: > $ sudo http_proxy=http://localhost:8888 yum -y install -- postgis30_11{,- > client} > ... > Resolving Dependencies > --> Running transaction check > ---> Package postgis30_11.x86_64 0:3.0.0alpha4-2.rhel7 will be installed > --> Processing Dependency: proj61 for package: postgis30_11-3.0.0alpha4- > 2.rhel7.x86_64 > --> Processing Dependency: libproj.so.15()(64bit) for package: postgis30_11- > 3.0.0alpha4-2.rhel7.x86_64 > ---> Package postgis30_11-client.x86_64 0:3.0.0alpha4-2.rhel7 will be > installed > --> Running transaction check > ---> Package proj61.x86_64 0:6.1.0-1.rhel7 will be installed > --> Processing Dependency: sqlite-libs >= 3.7 for package: proj61-6.1.0- > 1.rhel7.x86_64 > --> Finished Dependency Resolution > Error: Package: proj61-6.1.0-1.rhel7.x86_64 (pgdg10) > Requires: sqlite-libs >= 3.7 > You could try using --skip-broken to work around the problem I fixed this a couple of weeks ago in git. I am working on a major update for GIS components (including GDAL 3.0.1, Proj 6.2, etc). I think I can finish this work next week, and apply all updates at once. Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR
Attachment
Hi Devrim,
Are you planning to fix this soon for postgis30_10-utils?
sudo yum install postgis30_10-utils
>
> ...
>
> -> Processing Dependency: sqlite-libs >= 3.7 for package:
> proj61-6.1.0-1.rhel7.x86_64
> --> Finished Dependency Resolution
> Error: Package: proj61-6.1.0-1.rhel7.x86_64 (pgdg10)
> Requires: sqlite-libs >= 3.7
>
> ...
>
> -> Processing Dependency: sqlite-libs >= 3.7 for package:
> proj61-6.1.0-1.rhel7.x86_64
> --> Finished Dependency Resolution
> Error: Package: proj61-6.1.0-1.rhel7.x86_64 (pgdg10)
> Requires: sqlite-libs >= 3.7
Thanks,
Joe
On Sat, Sep 14, 2019 at 11:28 AM Devrim Gündüz <devrim@gunduz.org> wrote:
Hi,
On Fri, 2019-09-13 at 16:39 -0500, Justin Pryzby wrote:
> $ sudo http_proxy=http://localhost:8888 yum -y install -- postgis30_11{,-
> client}
> ...
> Resolving Dependencies
> --> Running transaction check
> ---> Package postgis30_11.x86_64 0:3.0.0alpha4-2.rhel7 will be installed
> --> Processing Dependency: proj61 for package: postgis30_11-3.0.0alpha4-
> 2.rhel7.x86_64
> --> Processing Dependency: libproj.so.15()(64bit) for package: postgis30_11-
> 3.0.0alpha4-2.rhel7.x86_64
> ---> Package postgis30_11-client.x86_64 0:3.0.0alpha4-2.rhel7 will be
> installed
> --> Running transaction check
> ---> Package proj61.x86_64 0:6.1.0-1.rhel7 will be installed
> --> Processing Dependency: sqlite-libs >= 3.7 for package: proj61-6.1.0-
> 1.rhel7.x86_64
> --> Finished Dependency Resolution
> Error: Package: proj61-6.1.0-1.rhel7.x86_64 (pgdg10)
> Requires: sqlite-libs >= 3.7
> You could try using --skip-broken to work around the problem
I fixed this a couple of weeks ago in git. I am working on a major update for
GIS components (including GDAL 3.0.1, Proj 6.2, etc). I think I can finish this
work next week, and apply all updates at once.
Regards,
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR
On Mon, Sep 16, 2019 at 7:42 AM Joe McEttrick <mcettrickwork@gmail.com> wrote:
Hi Devrim,Are you planning to fix this soon for postgis30_10-utils?sudo yum install postgis30_10-utils
>
> ...
>
> -> Processing Dependency: sqlite-libs >= 3.7 for package:
> proj61-6.1.0-1.rhel7.x86_64
> --> Finished Dependency Resolution
> Error: Package: proj61-6.1.0-1.rhel7.x86_64 (pgdg10)
> Requires: sqlite-libs >= 3.7Thanks,Joe
I'm waiting on this to do some upgrade testing as well.
Related note: cannot find any 12beta packages to test with in the repo, wondering if I'm doing something wrong.
P.
On Thu, Sep 19, 2019 at 03:45:54PM -0700, Paul Ramsey wrote: > On Mon, Sep 16, 2019 at 7:42 AM Joe McEttrick <mcettrickwork@gmail.com> wrote: > > Related note: cannot find any 12beta packages to test with in the repo, > wondering if I'm doing something wrong. They're present (but RH7 package not working for me, as mentioned in this thread) https://download.postgresql.org/pub/repos/yum/testing/12/redhat/rhel-7-x86_64/ postgresql12-12beta1-1PGDG.rhel7.x86_64.rpm 2019-Jun-05 21:35:14 1.7M application/x-redhat-package-manager postgresql12-12beta2-1PGDG.rhel7.x86_64.rpm 2019-Jun-19 18:09:18 1.7M application/x-redhat-package-manager postgresql12-12beta3-1PGDG.rhel7.x86_64.rpm 2019-Aug-07 22:14:27 1.7M application/x-redhat-package-manager postgresql12-12beta3-2PGDG.rhel7.x86_64.rpm 2019-Sep-01 21:08:47 1.7M application/x-redhat-package-manager postgresql12-12beta4-1PGDG.rhel7.x86_64.rpm 2019-Sep-13 15:41:22 1.7M application/x-redhat-package-manager https://download.postgresql.org/pub/repos/yum/testing/12/redhat/rhel-6-x86_64/ postgresql12-12beta1-1PGDG.rhel6.x86_64.rpm 2019-May-23 07:49:47 1.8M application/x-redhat-package-manager postgresql12-12beta2-1PGDG.rhel6.x86_64.rpm 2019-Jun-19 16:34:47 1.8M application/x-redhat-package-manager postgresql12-12beta3-1PGDG.rhel6.x86_64.rpm 2019-Aug-22 13:06:16 1.8M application/x-redhat-package-manager postgresql12-12beta4-1PGDG.rhel6.x86_64.rpm 2019-Sep-13 11:13:53 1.8M application/x-redhat-package-manager postgresql12-12beta4-2PGDG.rhel6.x86_64.rpm 2019-Sep-13 14:48:29 1.8M application/x-redhat-package-manager Note, you have to use yum --enablerepo='pgdg12-updates-testing', or set enabled=1 [pgdg12-updates-testing] name=PostgreSQL 12 $releasever - $basearch baseurl=https://download.postgresql.org/pub/repos/yum/testing/12/redhat/rhel-$releasever-$basearch enabled=1 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG Justin
On Thu, Sep 19, 2019 at 05:52:10PM -0500, Justin Pryzby wrote: > On Thu, Sep 19, 2019 at 03:45:54PM -0700, Paul Ramsey wrote: > > On Mon, Sep 16, 2019 at 7:42 AM Joe McEttrick <mcettrickwork@gmail.com> wrote: > > > > Related note: cannot find any 12beta packages to test with in the repo, > > wondering if I'm doing something wrong. > > They're present (but RH7 package not working for me, as mentioned in this > thread) I take that back, they're working now, since postgis was updated couple days ago: postgis30_12-utils-3.0.0alpha4-4.rhel7.x86_64.rpm 2019-Sep-17 12:30:26 36.9K application/x-redhat-package-manager postgis30_12-gui-3.0.0alpha4-4.rhel7.x86_64.rpm 2019-Sep-17 12:30:26 190.0K application/x-redhat-package-manager postgis30_12-debuginfo-3.0.0alpha4-4.rhel7.x86_64.rpm 2019-Sep-17 12:30:26 775.5K application/x-redhat-package-manager postgis30_12-docs-3.0.0alpha4-4.rhel7.x86_64.rpm 2019-Sep-17 12:30:25 4.4M application/x-redhat-package-manager postgis30_12-devel-3.0.0alpha4-4.rhel7.x86_64.rpm 2019-Sep-17 12:30:25 3.1K application/x-redhat-package-manager postgis30_12-client-3.0.0alpha4-4.rhel7.x86_64.rpm 2019-Sep-17 12:30:25 266.4K application/x-redhat-package-manager postgis30_12-3.0.0alpha4-4.rhel7.x86_64.rpm 2019-Sep-17 12:30:25 4.5M application/x-redhat-package-manager Thanks! Justin
On Thu, Sep 19, 2019 at 06:39:06PM -0500, Justin Pryzby wrote: > > They're present (but RH7 package not working for me, as mentioned in this > > thread) > > I take that back, they're working now, since postgis was updated couple days ago: Hi, sorry for the confusion...but this is still an issue for postgis30_11 (but 12 works ok). On Fri, Sep 13, 2019 at 04:39:09PM -0500, Justin Pryzby wrote: > $ sudo http_proxy=http://localhost:8888 yum -y install -- postgis30_11{,-client} > ... > Resolving Dependencies ... > Error: Package: proj61-6.1.0-1.rhel7.x86_64 (pgdg10) > Requires: sqlite-libs >= 3.7
Hi, On Fri, 2019-09-13 at 16:39 -0500, Justin Pryzby wrote: > --> Processing Dependency: sqlite-libs >= 3.7 for package: proj61-6.1.0- > 1.rhel7.x86_64 > --> Finished Dependency Resolution > Error: Package: proj61-6.1.0-1.rhel7.x86_64 (pgdg10) > Requires: sqlite-libs >= 3.7 Pushed new updates to the repo. Can you please test? They are in 9.4 to 11 (both stable and testing repos) and v12 (testing) repositories. Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR
Attachment
On Tue, Sep 24, 2019, at 5:18 PM, Devrim Gündüz wrote: > > Hi, > > On Fri, 2019-09-13 at 16:39 -0500, Justin Pryzby wrote: > > --> Processing Dependency: sqlite-libs >= 3.7 for package: proj61-6.1.0- > > 1.rhel7.x86_64 > > --> Finished Dependency Resolution > > Error: Package: proj61-6.1.0-1.rhel7.x86_64 (pgdg10) > > Requires: sqlite-libs >= 3.7 > > Pushed new updates to the repo. Can you please test? > > They are in 9.4 to 11 (both stable and testing repos) and v12 (testing) > repositories. Confirmed postgis30_11 no longer shows errors before confirming the install. Thanks! V/r, James Cassell
On Tue, Sep 24, 2019 at 10:18:42PM +0100, Devrim Gündüz wrote: > On Fri, 2019-09-13 at 16:39 -0500, Justin Pryzby wrote: > > --> Processing Dependency: sqlite-libs >= 3.7 for package: proj61-6.1.0- > > 1.rhel7.x86_64 > > --> Finished Dependency Resolution > > Error: Package: proj61-6.1.0-1.rhel7.x86_64 (pgdg10) > > Requires: sqlite-libs >= 3.7 > > Pushed new updates to the repo. Can you please test? > > They are in 9.4 to 11 (both stable and testing repos) and v12 (testing) > repositories. Confirmed I was able to install postgis30_11 (but didn't test the upgrade, since we already worked around it to be able to install 12b4). I think maybe the version number will sort wrong, same as the issue I reported with postgresql12-12beta1: |postgis30_11-3.0.0alpha4-4.rhel7.x86_64 Maybe it should be ~alpha4 or something? On Thu, May 23, 2019 at 09:55:00AM -0500, Justin Pryzby wrote: > I'm wondering how versioning on PGDG RPMs is intended to work. > Yum seems to thinks that the "nightly builds" are of higher version number than > beta. > > [pryzbyj@dev ~]$ yum list --enablerepo='pgdg12-updates-testing' --showdu postgresql12 > ... > Installed Packages > postgresql12.x86_64 12.0-devel_20190502_1PGDG.rhel7 @pgdg12-updates-testing > Available Packages > postgresql12.x86_64 12beta1-1PGDG.rhel7 pgdg12-updates-testing > > [pryzbyj@dev ~]$ sudo yum --enablerepo=pgdg12-updates-testing install postgresql12{-server,-debuginfo,-contrib} #12beta1-1PGDG.rhel7.x86_64 > Package matching postgresql12-server-12beta1-1PGDG.rhel7.x86_64 already installed. Checking for update. > Package matching postgresql12-debuginfo-12beta1-1PGDG.rhel7.x86_64 already installed. Checking for update. > Package matching postgresql12-contrib-12beta1-1PGDG.rhel7.x86_64 already installed. Checking for update. > Nothing to do > > I made it work like this: > [pryzbyj@dev ~]$ sudo yum --enablerepo=pgdg12-updates-testing downgrade postgresql12{,-libs,-server,-debuginfo,-contrib}-12beta1-1PGDG.rhel7.x86_64 > > ..which seems to prove that's what's going on. > > I recall that debian handles that using "~", like 12~beta1. > > At least, it should be called 12devel and 12beta1 for consistency? Or > 12.0devel and 12.0beta1.
Hi, On Tue, 2019-09-24 at 17:54 -0500, Justin Pryzby wrote: > I think maybe the version number will sort wrong, same as the issue I > reported > with postgresql12-12beta1: > > postgis30_11-3.0.0alpha4-4.rhel7.x86_64 > > Maybe it should be ~alpha4 or something? Yeah, I will fix it in v13 cycle. Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR
Attachment
Confirm fixed for postgis30_10.
Thanks!
On Tue, Sep 24, 2019 at 6:54 PM Justin Pryzby <pryzby@telsasoft.com> wrote:
On Tue, Sep 24, 2019 at 10:18:42PM +0100, Devrim Gündüz wrote:
> On Fri, 2019-09-13 at 16:39 -0500, Justin Pryzby wrote:
> > --> Processing Dependency: sqlite-libs >= 3.7 for package: proj61-6.1.0-
> > 1.rhel7.x86_64
> > --> Finished Dependency Resolution
> > Error: Package: proj61-6.1.0-1.rhel7.x86_64 (pgdg10)
> > Requires: sqlite-libs >= 3.7
>
> Pushed new updates to the repo. Can you please test?
>
> They are in 9.4 to 11 (both stable and testing repos) and v12 (testing)
> repositories.
Confirmed I was able to install postgis30_11 (but didn't test the upgrade,
since we already worked around it to be able to install 12b4).
I think maybe the version number will sort wrong, same as the issue I reported
with postgresql12-12beta1:
|postgis30_11-3.0.0alpha4-4.rhel7.x86_64
Maybe it should be ~alpha4 or something?
On Thu, May 23, 2019 at 09:55:00AM -0500, Justin Pryzby wrote:
> I'm wondering how versioning on PGDG RPMs is intended to work.
> Yum seems to thinks that the "nightly builds" are of higher version number than
> beta.
>
> [pryzbyj@dev ~]$ yum list --enablerepo='pgdg12-updates-testing' --showdu postgresql12
> ...
> Installed Packages
> postgresql12.x86_64 12.0-devel_20190502_1PGDG.rhel7 @pgdg12-updates-testing
> Available Packages
> postgresql12.x86_64 12beta1-1PGDG.rhel7 pgdg12-updates-testing
>
> [pryzbyj@dev ~]$ sudo yum --enablerepo=pgdg12-updates-testing install postgresql12{-server,-debuginfo,-contrib} #12beta1-1PGDG.rhel7.x86_64
> Package matching postgresql12-server-12beta1-1PGDG.rhel7.x86_64 already installed. Checking for update.
> Package matching postgresql12-debuginfo-12beta1-1PGDG.rhel7.x86_64 already installed. Checking for update.
> Package matching postgresql12-contrib-12beta1-1PGDG.rhel7.x86_64 already installed. Checking for update.
> Nothing to do
>
> I made it work like this:
> [pryzbyj@dev ~]$ sudo yum --enablerepo=pgdg12-updates-testing downgrade postgresql12{,-libs,-server,-debuginfo,-contrib}-12beta1-1PGDG.rhel7.x86_64
>
> ..which seems to prove that's what's going on.
>
> I recall that debian handles that using "~", like 12~beta1.
>
> At least, it should be called 12devel and 12beta1 for consistency? Or
> 12.0devel and 12.0beta1.
Hi, On Wed, 2019-09-25 at 10:40 -0400, Joe McEttrick wrote: > Confirm fixed for postgis30_10. Thanks for testing! I just pushed -6, which fixes a broken symlink issue (reported by Paul Ramsey). I won't touch this for some time, I promise :-) Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR
Attachment
Hi Paul, On Thu, 2019-09-19 at 15:45 -0700, Paul Ramsey wrote: > Related note: cannot find any 12beta packages to test with in the repo, > wondering if I'm doing something wrong. https://people.planetpostgresql.org/devrim/index.php?/archives/101-Installing-PostgreSQL-12-betaRC-on-RHELCentOSFedora.html Cheers, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR
Attachment
Hi, On Fri, 2019-09-20 at 08:13 -0500, Justin Pryzby wrote: > Hi, sorry for the confusion...but this is still an issue for postgis30_11 > (but 12 works ok). Yeah, that update was only for v12 testing repos. The recent updates went to all of'em. Cheers, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR
Attachment
On Tue, Sep 24, 2019 at 10:18:42PM +0100, Devrim Gündüz wrote: > On Fri, 2019-09-13 at 16:39 -0500, Justin Pryzby wrote: > > --> Processing Dependency: sqlite-libs >= 3.7 for package: proj61-6.1.0- > > 1.rhel7.x86_64 > > --> Finished Dependency Resolution > > Error: Package: proj61-6.1.0-1.rhel7.x86_64 (pgdg10) > > Requires: sqlite-libs >= 3.7 > > Pushed new updates to the repo. Can you please test? I'm trying to install on a new centos7 VM. Some packages are built for pg10 and 11 but not yet 12, which is sucking in pg10/11 libs, which is odd. [pryzbyj@tecalert01 ~]$ sudo rpm -e postgresql11{,-libs,-devel} error: Failed dependencies: postgresql11-devel is needed by (installed) libpqxx-devel-1:5.0.1-2.rhel7.1.x86_64 [pryzbyj@tecalert01 ~]$ sudo rpm -e postgresql10-libs error: Failed dependencies: postgresql10-libs is needed by (installed) python2-psycopg2-2.8.3-1.rhel7.x86_64 Also these aren't available yet (but I assume that's known and resolved after release): No package pgfincore12 available. No package pg_repack12 available. Thanks, Justin
Hi On Thu, 2019-09-26 at 17:12 -0500, Justin Pryzby wrote: > No package pgfincore12 available. Please use pg_prewarm. pgfincore does not have v12 support (and does not compile anywa) > No package pg_repack12 available. https://github.com/reorg/pg_repack/pull/207 https://github.com/reorg/pg_repack/issues/216 Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR
Attachment
On Thu, Oct 03, 2019 at 12:18:04AM +0100, Devrim Gündüz wrote: > > Hi > > On Thu, 2019-09-26 at 17:12 -0500, Justin Pryzby wrote: > > No package pgfincore12 available. > > Please use pg_prewarm. pgfincore does not have v12 support (and does not > compile anywa) > > > No package pg_repack12 available. > > https://github.com/reorg/pg_repack/pull/207 > https://github.com/reorg/pg_repack/issues/216 Thanks. For pgfincore, I don't use it to read blocks, but (very infrequently) in a tuning query to check "if incore"... I compiled it fine just now for HEAD (under ubuntu). make PG_CONFIG=/usr/local/pgsql/bin/pg_config install waiting for server to start....2019-10-02 18:33:44.409 CDT [25266] LOG: starting PostgreSQL 13devel on x86_64-pc-linux-gnu,compiled by gcc (Ubuntu 4.9.2-10ubuntu13) 4.9.2, 64-bit 2019-10-02 18:33:44.410 CDT [25266] LOG: listening on IPv4 address "127.0.0.1", port 5678 2019-10-02 18:33:44.492 CDT [25266] LOG: listening on Unix socket "/tmp/.s.PGSQL.5678" 2019-10-02 18:33:44.614 CDT [25277] LOG: database system was shut down at 2019-10-02 12:07:06 CDT 2019-10-02 18:33:44.649 CDT [25266] LOG: database system is ready to accept connections done server started postgres=# CREATE EXTENSION pgfincore; CREATE EXTENSION postgres=# SELECT * FROM pgfincore('pg_class'); relpath | segment | os_page_size | rel_os_pages | pages_mem | group_mem | os_pages_free | databit | pages_dirty| group_dirty -----------------+---------+--------------+--------------+-----------+-----------+---------------+---------+-------------+------------- base/12708/1259 | 0 | 4096 | 26 | 26 | 1 | 196465 | | 0| 0 (1 row) postgres=# SELECT version(); version | PostgreSQL 13devel on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 4.9.2-10ubuntu13) 4.9.2, 64-bit Justin
Hi Justin, On Wed, 2019-10-02 at 18:37 -0500, Justin Pryzby wrote: > I compiled it fine just now for HEAD (under ubuntu). Thanks for the tip. I was not aware that I was still pushing 1.1.2, where latest version is 1.2.1 :( Updated to 1.2.1, and added the patch: https://git.postgresql.org/gitweb/?p=pgrpms.git;a=commit;h=4c2b8e8ed82f3a942937948e992a86e65eb4c59c Will release packages soon. Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR
Attachment
libpqxx-devel doesn't seem to exist for pg12. I reported this last year for pg11 and previous year for pg10; now, it's affecting pg12. Find quoted below our prior communication. On Thu, Sep 26, 2019 at 05:12:44PM -0500, Justin Pryzby wrote: > On Tue, Sep 24, 2019 at 10:18:42PM +0100, Devrim Gündüz wrote: > > On Fri, 2019-09-13 at 16:39 -0500, Justin Pryzby wrote: > > > --> Processing Dependency: sqlite-libs >= 3.7 for package: proj61-6.1.0-1.rhel7.x86_64 > > > --> Finished Dependency Resolution > > > Error: Package: proj61-6.1.0-1.rhel7.x86_64 (pgdg10) > > > Requires: sqlite-libs >= 3.7 > > > > Pushed new updates to the repo. Can you please test? > > I'm trying to install on a new centos7 VM. > > Some packages are built for pg10 and 11 but not yet 12, which is sucking in > pg10/11 libs, which is odd. > > [pryzbyj@tecalert01 ~]$ sudo rpm -e postgresql11{,-libs,-devel} > error: Failed dependencies: > postgresql11-devel is needed by (installed) libpqxx-devel-1:5.0.1-2.rhel7.1.x86_64 > [pryzbyj@tecalert01 ~]$ sudo rpm -e postgresql10-libs > error: Failed dependencies: > postgresql10-libs is needed by (installed) python2-psycopg2-2.8.3-1.rhel7.x86_64 > > Also these aren't available yet (but I assume that's known and resolved after release): > > No package pgfincore12 available. > No package pg_repack12 available. On Thu, Dec 14, 2017 at 09:26:21PM -0600, Justin Pryzby wrote: > On Fri, Dec 15, 2017 at 06:05:51AM +0300, Devrim Gündüz wrote: > > On Fri, 2017-12-08 at 13:33 -0600, Justin Pryzby wrote: > > > I compared lists of RPMs available for PG10 vs PG96 for RHEL6 and found > > > that these seem to be missing for PG10. That primarily affects new > > > installs, users who upgrade from PG10 are likely to have the PG96 PGDG > > > repo still. > > > libpqxx? > > It is already in the repo (5.0.1-2) > > Not for centos6 (nor RHEL6) ? > https://yum.postgresql.org/10/redhat/rhel-6-x86_64/
Re: libpqxx-devel for pg12 on c7 (was: Re: cannot install postgis30/ rhel7)
From
Devrim Gündüz
Date:
Hi, On Sun, 2020-05-31 at 17:23 -0500, Justin Pryzby wrote: > libpqxx-devel doesn't seem to exist for pg12. Newer libpqxx releases do not build on RHEL 7, so I also stopped building on PG releases as well. Still, built 5.0.1 on PG12. They will sync in 1 hour. Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR
Attachment
Re: libpqxx-devel for pg12 on c7 (was: Re: cannot install postgis30 / rhel7)
From
Justin Pryzby
Date:
libpqxx-devel doesn't exist for pg13 - should it ? Copying most recent message about this package. On Mon, Jun 01, 2020 at 01:26:27PM +0100, Devrim Gündüz wrote: > On Sun, 2020-05-31 at 17:23 -0500, Justin Pryzby wrote: > > libpqxx-devel doesn't seem to exist for pg12. > > Newer libpqxx releases do not build on RHEL 7, so I also stopped > building on PG releases as well. > > Still, built 5.0.1 on PG12. They will sync in 1 hour.
Re: libpqxx-devel for pg12 on c7 (was: Re: cannot install postgis30 / rhel7)
From
Devrim Gündüz
Date:
Hi, On Wed, 2020-09-09 at 20:36 -0500, Justin Pryzby wrote: > libpqxx-devel doesn't exist for pg13 - should it ? I just built a few packages for v13. I'll start builds next week, along with RC1 release. Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR
Attachment
Re: libpqxx-devel for pg12 on c7 (was: Re: cannot install postgis30 / rhel7)
From
Justin Pryzby
Date:
I'm still missing libpqxx, pg_repack13, and pgfincore13 On Thu, Sep 10, 2020 at 01:08:46PM +0100, Devrim Gündüz wrote: > On Wed, 2020-09-09 at 20:36 -0500, Justin Pryzby wrote: > > libpqxx-devel doesn't exist for pg13 - should it ? > > I just built a few packages for v13. I'll start builds next week, along > with RC1 release. -- Justin Pryzby System Administrator Telsasoft +1-952-707-8581
Re: libpqxx-devel for pg12 on c7 (was: Re: cannot install postgis30 / rhel7)
From
Devrim Gündüz
Date:
Hi Justin, On Thu, 2020-09-24 at 17:32 -0500, Justin Pryzby wrote: > I'm still missing libpqxx, Pushed 7.2.0 to RHEL 8 and Fedora repos. > pg_repack13 Does not work against v13: https://github.com/reorg/pg_repack/issues/246 > and pgfincore13 Pushed. Thanks for the heads up. Out of curiosity: Why don't you switch to pg_prewarm? Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR
Attachment
Re: libpqxx-devel for pg12 on c7 (was: Re: cannot install postgis30 / rhel7)
From
Justin Pryzby
Date:
On Fri, Sep 25, 2020 at 03:39:50PM +0100, Devrim Gündüz wrote: > On Thu, 2020-09-24 at 17:32 -0500, Justin Pryzby wrote: > > I'm still missing libpqxx, > Pushed 7.2.0 to RHEL 8 and Fedora repos. What about c7 ? > Out of curiosity: Why don't you switch to pg_prewarm? We talked about this last year: On Wed, Oct 02, 2019 at 06:37:11PM -0500, Justin Pryzby wrote: > On Thu, Oct 03, 2019 at 12:18:04AM +0100, Devrim Gündüz wrote: > > On Thu, 2019-09-26 at 17:12 -0500, Justin Pryzby wrote: > > > No package pgfincore12 available. > > > > Please use pg_prewarm. pgfincore does not have v12 support (and does not > > compile anywa) > > Thanks. > > For pgfincore, I don't use it to read blocks, but (very infrequently) in a > tuning query to check "if incore"... -- Justin
Re: libpqxx-devel for pg12 on c7 (was: Re: cannot install postgis30 / rhel7)
From
Devrim Gündüz
Date:
Hi, On Fri, 2020-09-25 at 11:30 -0500, Justin Pryzby wrote: > > Pushed 7.2.0 to RHEL 8 and Fedora repos. > > What about c7 ? Never versions of libpqxx does not compile on RHEL 7. Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR
Attachment
Re: libpqxx-devel for pg12 on c7 (was: Re: cannot install postgis30 / rhel7)
From
Justin Pryzby
Date:
On Sun, Sep 27, 2020 at 01:54:09PM +0100, Devrim Gündüz wrote: > On Fri, 2020-09-25 at 11:30 -0500, Justin Pryzby wrote: > > > Pushed 7.2.0 to RHEL 8 and Fedora repos. > > > > What about c7 ? > > Never versions of libpqxx does not compile on RHEL 7. Right, I guess we went over this earlier this year. It's no problem, since it's in earlier PGDG repos, and in EPEL, but it's odd to me that we'll end up using PGDG11 libpqxx for another year. BTW I noticed this looks to be a real issue ? $ time repoclosure -n -l base -l epel -l centos-sclo-rh -r pgdg-common -r pgdg13 ... package: pgpoolAdmin-4.0.1-1.rhel7.noarch from pgdg-common unresolved deps: pgpool-II-12 >= 0:4.0.1 -- Justin
Re: libpqxx-devel for pg12 on c7 (was: Re: cannot install postgis30 / rhel7)
From
Devrim Gündüz
Date:
Hi, On Sun, 2020-09-27 at 09:46 -0500, Justin Pryzby wrote: > BTW I noticed this looks to be a real issue ? > > > > $ time repoclosure -n -l base -l epel -l centos-sclo-rh -r pgdg- > common -r pgdg13 > > ... > > package: pgpoolAdmin-4.0.1-1.rhel7.noarch from pgdg-common > > unresolved deps: > > pgpool-II-12 >= 0:4.0.1 I'm waiting for pgPool folks to release 4.2 for v13 compatibility (also asked them if the current releases work against v13 or not) Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR