Thread: cannot install postgis30 / rhel7

cannot install postgis30 / rhel7

From
Justin Pryzby
Date:
$ 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



Re: cannot install postgis30 / rhel7

From
Devrim Gündüz
Date:
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

Re: cannot install postgis30 / rhel7

From
Joe McEttrick
Date:
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

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

Re: cannot install postgis30 / rhel7

From
Paul Ramsey
Date:


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.7

Thanks,
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.

Re: cannot install postgis30 / rhel7

From
Justin Pryzby
Date:
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



Re: cannot install postgis30 / rhel7

From
Justin Pryzby
Date:
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



Re: cannot install postgis30_11 / rhel7

From
Justin Pryzby
Date:
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



Re: cannot install postgis30 / rhel7

From
Devrim Gündüz
Date:
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

Re: cannot install postgis30 / rhel7

From
"James Cassell"
Date:
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



Re: cannot install postgis30 / rhel7

From
Justin Pryzby
Date:
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.



Re: cannot install postgis30 / rhel7

From
Devrim Gündüz
Date:
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

Re: cannot install postgis30 / rhel7

From
Joe McEttrick
Date:
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.


Re: cannot install postgis30 / rhel7

From
Devrim Gündüz
Date:
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

Re: cannot install postgis30 / rhel7

From
Devrim Gündüz
Date:
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

Re: cannot install postgis30_11 / rhel7

From
Devrim Gündüz
Date:
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

Re: cannot install postgis30 / rhel7

From
Justin Pryzby
Date:
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



Re: cannot install postgis30 / rhel7

From
Devrim Gündüz
Date:
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

Re: pgfincore (Re: cannot install postgis30 / rhel7)

From
Justin Pryzby
Date:
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



Re: pgfincore (Re: cannot install postgis30 / rhel7)

From
Devrim Gündüz
Date:
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 for pg12 on c7 (was: Re: cannot install postgis30 /rhel7)

From
Justin Pryzby
Date:
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

Attachment