subscription-manager register

dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
dnf -qy module disable postgresql
dnf install -y postgresql15-server
/usr/pgsql-15/bin/postgresql-15-setup initdb
systemctl enable postgresql-15
systemctl start postgresql-15

passwd postgres
su - postgres
psql
\l
alter user postgres with password 'inoss';
create user inoss;
alter user inoss2 with password 'inoss2';

yum install psqlodbc
Installing:
 postgresql-odbc          x86_64  10.03.0000-3.el8_6  rhel-8-for-x86_64-appstream-rpms   430 k
Installing dependencies:
 libpq5                   x86_64  16.2-42PGDG.rhel8   pgdg-common                        251 k
 unixODBC                 x86_64  2.3.7-1.el8         rhel-8-for-x86_64-appstream-rpms   458 k

vim /var/lib/pgsql/15/data/pg_hba.conf
local   all             all                                     trust
host    all             all             127.0.0.1/32            trust
host    all             all             0.0.0.0/0               trust
host    all             all             ::1/128                 trust

vim /var/lib/pgsql/15/data/postgresql.conf
add listen IP to *

ele tem a lib psqlodbcw.so em lib64 e não /usr/pgsq-15/etc, portanto perfeito
/usr/lib64/psqlodbcw.so

dnf install python3.11 python3.11-pip
#yum install python3-devel
pip3.11 install pyodbc                # senao instala para a versao 3.6

GRANT ALL PRIVILEGES ON DATABASE dbcarros TO user1;
GRANT ALL ON SCHEMA dbcarros TO user1;
ALTER TABLE carros OWNER TO user1;

\dp carros # display permissions
\l+ dbcarros









"/etc/odbcinst.ini","[PostgreSQL]"
"/etc/odbcinst.ini","Driver64        = /usr/lib64/psqlodbcw.so"
"/etc/odbcinst.ini","Setup64         = /usr/lib64/libodbcpsqlS.so"