how stable and reliable is Rocky Linux with Postgresql?
I would say as stable as it is under RHEL.
On Rocky 9.1, where is package postgresql-devel, need it to install PyGreSQL, but it’s not in the available postgresql packages list ?
Check the ‘crb’ repo.
it seems postgresql-private-devel conflicts with libpq-devel, which one should I install ?
[root@localhost ~]# LANG=C dnf install -y postgresql-server-devel postgresql-private-devel libpq-devel libpgtypes Error: Problem: package postgresql-private-devel-13.7-1.el9_0.x86_64 conflicts with libpq-devel provided by libpq-devel-13.5-1.el9.x86_64 - cannot install the best candidate for the job - conflicting requests (try to add '--allowerasing' to command line to replace conflicting packages or '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate packages)
Any particular reason why you are attempting to install the devel versions, when it would be far easier to just do:
dnf install postgresql-server
or do you have a specific requirement and why use use devel versions?
That depends on what you are developing. It looks like the
libpq-devel is for “normal users”.
Name : libpq-devel Repository : appstream Summary : Development files for building PostgreSQL client tools Description : The libpq package provides the essential shared library for any PostgreSQL : client program or interface. You will need to install this package to build any : package or any clients that need to connect to a PostgreSQL server.
Name : postgresql-private-devel Repository : crb Summary : PostgreSQL development header files for this build of PostgreSQL server Description : The postgresql-private-devel package contains the header files and libraries : needed to compile C or C++ applications which will directly interact : with a PostgreSQL database management server. : You need to install this package if you want to develop applications which : will interact with a PostgreSQL server.
Ok, I guess I’ll need postgresql-private-devel in order to install PyGreSQL 3.8.1 which needs the exported pg_*printf functions.