Postgresql in Rocky linux

how stable and reliable is Rocky Linux with Postgresql?

I would say as stable as it is under RHEL.

Hi,

On Rocky 9.1, where is package postgresql-devel, need it to install PyGreSQL, but it’s not in the available postgresql packages list ?

Thanks,

Check the ‘crb’ repo.

Hi jlethone,

it worked.

Thanks,

Hi,

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.

Thanks,